Excel FunctionsExcel DAYS360 Function


Unlike the DAYS and DATEDIF function, in which, excel calculates the actual days between two dates this function is used to return days between two dates assuming 360 days in a year (in other words assuming 30days in each month).  


The DAYS function syntax has the following arguments:

  • Start_date Required.

A date that represents the start date.

  • End_date Required.

A date that represents the start date.

If start_date occurs after end_date, the DAYS360 function returns a negative number. Dates should be entered by using the DATE function or derived from the results of other formulas or functions.

  • Method Optional.

A logical value that specifies whether to use the U.S. or European method in the calculation.

Organically grow the holistic world view of disruptive innovation via empowerment.
OUR LOCATIONSWhere to find us
GET IN TOUCHSocial links
Taking seamless key performance indicators offline to maximise the long tail.

Copyright by Excel Accountancy. All rights reserved.

Copyright by BoldThemes. All rights reserved.