Module: Editor
Version: 2.2.1 +
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: 28-08-2014
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. Note that the number of days in the period does not contain the starting date.