• 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

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

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