Periods and Days
The Periods and Days calculation lets you calculate the number of full periods and the number of stub days between two calendar dates for a given interval.
The number of full periods is calculated by going from the second date back to the first date in steps that are the size of a period. If the second date falls on the last day of the month, then all preceding periods are assumed to also end on the last day of the month.
Any remaining days are counted as stub days.
Input
| • start date |
| • end date |
| • period interval |
Results
| • number of full periods |
| • number of stub days |
Examples
| • | How many full periods and stub days are there between January 29, 2008, to February 29, 2008, if the period interval is monthly?
Answer: 1 full period and 2 stub days. |
||||||||||||||||||
| • | How many full periods and stub days are there between February 29, 2008, to March 31, 2008, if the period interval is monthly?
Answer: 3 full periods. |
Related topics
| Day count conventions |
| Simple Interest between Dates |
| Actuarial Interest between Dates |