The DAYS360 function

Share on facebook
Share on twitter
Share on linkedin
Share on telegram
Share on whatsapp


The DAYS360 function <Article <Blog | SumProduct are Excel training experts: financial modeling, strategic data modeling, model audit, planning and strategy, training courses, tips and online knowledge base

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.

Subscribe to our Newsletter

We will not send you SPAM mail. We hate it as much as you.