Module:Editor
Version:2.2.1 +
Description
The formula 'Days360Excel' returns the number of days between two dates based on a 360 day year using the Microsoft Excel calculation method. 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.
Starting from Futurama 24.02, the formula has been updated to align with Excel. To mainain compatibility with the previous behavior, a Compatibility mode ('24_01') has been introduced.
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.
Method: this is a logical value that specifies the calculation method: U.S. (NASD) = False, European = True
Example
Description
Below here you will find some examples of the 'Days360Excel' formula:
Start_date: 1-1-2014
End_date: 30-1-2014
Method: True/False
Result: 29
Start_date: 1-1-2014
End_date: 31-1-2014
Method: False
Result: 30
Start_date: 1-1-2014
End_date: 31-1-2014
Method: True
Result: 29
Start_date: 1-1-2014
End_date: 1-2-2014
Method: True/False
Result: 30
Start_date: 1-1-2013
End_date: 1-3-2013
Method: True/False
Result: 60
Related Topics
- Days360: The formula 'Days360' returns the number of days between two dates based on a 360 day year.
Feedback
If you have any questions about this subject or if you want to provide us feedback please send us an e-mail.