Search

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:         28-08-2014

Result

Output:            5

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.

Related Topics

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

Feedback

If you have any questions about this subject or if you want to provide us feedback please send us an e-mail.

Updated: 2014-09-23