Version: 2.2.1 +
Type: Long or Double
Category: Date and Time
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.
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
Below here you will find some examples of the 'Days360Excel' formula:
- Days360: The formula 'Days360' returns the number of days between two dates based on a 360 day year.
If you have any questions about this subject or if you want to provide us feedback please send us an e-mail.