DAYS360 Function in Excel

The DAYS360 function in Excel returns the number of days between two dates based on a 360-day year (12 x 30 months). Calculations based on a 360-day year comes for certain accounting Reasons where all 12 months are considered to have 30 days.

Syntax for DAYS360 Function in Excel

DAYS360( start_date, end_date, [method] )

 

start_date The start of the period.
end_date The end of the period.
[method] An optional logical argument, which gives the method to be used in the calculation. IF FALSE US Method is used, IF TRUE European Method is used

 

Example of DAYS360 Function in Excel:

Formula:

days360 function in R 1

Results

days360 function in R 2

  • Row number 2 calculates Difference between Jan-1-2017 to Feb-1-2017 which actually 31 days but Because of DAYS360 Function we get 30 days
  • Start Date has to be less than end date or else it will result in negative vale which -30 days in row number 3.
  • If Start Date and End Date are same then difference between two days will be 0 days Which is shown in row number 4
  • Row number 5 calculates difference between Feb-1-2015 to Feb-1-2017, which are Actually 731 days, Because of DAYS360 Function we get 720 days

Note on Errors of DAYS360 Function in Excel:

  • #NUM! – Occurs if one or both of the supplied end_date and start_date arguments are numeric values, but are not recognized as valid dates.
  • #VALUE! – Occurs if one or both of the supplied start_date and end_date arguments are text values that cannot be interpreted as dates
  • #VALUE! –Also occurs when Supplied [Method] Argument is non Logical or non-Numeric.

previous DAYS360 Function in Excel                                                                                                                next DAYS360 Function in Excel