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.
Warning: Although you can input the dates as serial numbers, this is not recommended as the serial numbers may vary across different computer systems.
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 the example the Excel Date function is used to supply the end_date argument to the function in cell B4).