• 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 'DaysInPeriod' returns the number of days between two specified dates. The formula 'DaysInPeriod' is based on the real amount of days in a year. This is different from the formula 'Days360', that is based on a 360 day year.

## Parameters

Start_date:         this is the beginning of the period.

End_date:           this is the end of the period.

## Example

### Description

In the following example the formula 'DaysInPeriod' is used to get the number of days between two dates.

### Values parameters

Start_date:       23-08-2014

End_date:         23-09-2014

### Result

Output:            31

You can see that the outcome is 31, because august has 31 days. When you do the same with the formula 'Days360', you would get 30 as outcome.

## Related Topics

Days360: The formula 'Days360' returns the number of days between two dates based on a 360 day year.