Search

Module:Editor

Version:2.2.1 +

Type:Long or Double

Category: Date and Time

 

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.

Updated: 2014-09-23