Module:Editor
Version:2.2.1 + (Deprecated as of version 24.02)
Description
The formula 'Days360' returns the number of days between two dates based on a 360 day year. The formula assumes that every month has 30 days. The formula counts the number of days from the start date to the end date (the end date is not included). If the start date equals the end date the result will be 0, except if it is the 31st of the month. In this case the result will be 1.
This formula is deprecated as of version 24.02 and is no longer supported. Instead you should utilize the Days360Excel function with the parameter "Method" set to True, since this will give the same result. This change in formula will be automatically executed when opening the file in a new version.
Parameters
Start_date:
This is the date where it start counting the days.
End_date:
This is the date that it stop counting the days.
Example
Description
Below here you will find some examples of the 'Days360' formula:
Start_date:
1-1-2013
End_date:
30-1-2013
Result:
29
Start_date:
1-1-2013
End_date:
31-1-2013
Result:
29
Start_date:
1-1-2013
End_date:
1-2-2013
Result:
30
Start_date:
1-1-2013
End_date:
1-3-2013
Result:
60
Related Topics
- Days360Excel: The formula 'Days360Excel' returns the number of days between two dates based on a 360 day year using the Microsoft Excel calculation method.
Feedback
If you have any questions about this subject or if you want to provide us feedback please send us an e-mail.