• Futurama Formulas - Date and time
• Futurama Formulas - Math
• Futurama Formulas - Statistical
• Futurama Formulas - Text
• Futurama Formulas - Logical
• Futurama Formulas - Table
• Futurama Formulas - Document
• Futurama Formulas - Conversion
• Futurama Formulas - Matrix
• Creating custom formulas in Futurama

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.

## 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.