Learn How to Use Microsoft Excel DAYS360 Function
In this article, you will learn how to use the Microsoft Excel DAYS360 function and its prime function in Microsoft Excel. You will also get to know the Microsoft Excel DAYS360 function return value and syntax with the help of some examples.
Microsoft Excel DAYS360 Function
The main purpose of the DAYS360 function is to get the days between two dates in a 360-day year. That means the Microsoft Excel DAYS360 function returns the total number of days between the two specified dates based on a 360-day year. The calculation is made keeping 360-days in a year, keeping in mind specific accounting calculations where every month is considered to have 30 days.
DAYS360 Function Return Value
It returns a number representing days.
DAYS360 Function Syntax
= DAYS360(start-date, end-date, [method])
- start-date: It is the starting date.
- end-date: It is the end date.
- method: It is optional and used as per the day count basis. FALSE default (US meth0d), TRUE is the European method.
How to Use Microsoft Excel DAYS360 Function?
The DAYS360 function can be used in two ways:
- FALSE (US Method): When the start date is the last date of the month, it is set to the 30th day of a similar month. In case the end date is the last date of the month & the start date is less than 30, in this case, the end date is set as the 1st of the following month; if not, the end date is set to the 30th of the similar month.
- TRUE (European Method): Here, the start date and the end date is equal to the 31st of the month are set to the 30th of the same month.
Check out the list of all other articles:
- Learn How to Get nth Match in Microsoft Excel
- Learn How to Find Missing Values in Microsoft Excel
- Learn How to Get nth Smallest Value With Criteria in Microsoft Excel
- Learn How to Sort by Text Length in Microsoft Excel
- Learn How to Sort by Two Columns in Microsoft Excel
- Learn How to Sort by Random in Microsoft Excel
- Learn How to Sort by One Column in Microsoft Excel
- Learn How to Sort by Custom List in Microsoft Excel