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. The format of the function is shown in the spreadsheet on the left and the results are shown in the spreadsheet on the right.
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.|