keep in mind javascript is required for full website functionality.
Welcome back to our regular blog of Excel functions from A to Z. Today we look at the DAYS360 function.
The DAYS360 function
This function returns the number of days between two dates based on a year in 360 Days (twelve months of 30 days), used in some accounting calculations. You should use this function to help calculate payments if your accounting system is based on twelve months of 30 days.
The DAYS360 The function uses the following syntax to operate:
DAYS360 (start date, end_date, [method])
The DAYS360 The function has the following arguments:
- start date: this is mandatory and represents the start date
- final date: this is also required and represents the end date. And start date occurs after final date, the DAYS360 The function returns a negative number. Dates must be entered using the DATE function or derived from the results of other formulas or functions. For instance, use DATE(2008,5,23) to return the day 23 May 2008. Problems can arise if dates are entered as text
- Method: this argument is optional and is a logical value that specifies whether the American or European method will be used in the calculation, verbigracia.
Please, see my example below:
Soon we will continue with our functions from A to Z of Excel. Keep checking: there is a new blog post every business day.
You can find a full page of feature articles here.
Sign up to receive our newsletter