• 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 + (Deprecated as of version 24.02)

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.

This formula is deprecated as of version 24.02 and is no longer supported. Instead you should utilize the Days360Excel function with the parameter "Method" set to True, since this will give the same result. This change in formula will be automatically executed when opening the file in a new version.

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