The Excel Days360 function returns the number of days between 2 dates, based on a 360-day year (12 x 30 months).
The format of the function is:
where the arguments are as follows:
|start_date||-||The start of the period|
|end_date||-||The end of the period|
An optional logical argument, which gives the method to be used in the calculation. This can be either:
Note that the start_date and end_date arguments should be input as either:
- If you attempt to input the start_date and end_date as text, there is a chance that Excel may misinterpret this due to different date systems, or date interpretation settings.
The spreadsheets below show simple examples of the Excel Days360 function.
In the above example :
Note also that, as recommended by Microsoft, in all four calls to the Days360 function, the start_date and end_date arguments have been supplied as either cell references or the return values from functions (in cell B4, the Date function is used to supply the end_date argument).
Further information and examples of the Excel DAYS360 function can be found on the Microsoft Office website.
|#NUM!||-||Occurs if one or both of the supplied arguments are numeric values, but are not recognised as valid dates.|
|#VALUE!||-||Occurs if one or both of the supplied arguments are text values that can not be interpreted as dates.|