Version: 2.2.1 +
Type: Long or Double
Category: Date and Time
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.
Start_date: this is the beginning of the period.
End_date: this is the end of the period.
In the following example the formula 'DaysInPeriod' is used to get the number of days between two dates.
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.