Date Series
The Dates Series calculation lets you set up a series of periodic dates going forward or backward from a given date and view the number of days for each period using different date adjustment options and different day count methods.
Note: date adjustment options are only available for semimonthly or greater intervals.
Input
| • period interval | |
| • number of periods | |
| • start date | |
| • date adjustment | |
| • none | |
| • end of month | |
• preceding weekday |
|
| • preceding modified | |
| • following weekday | |
| • following modified | |
Results
| • exact time in days |
| • approximate time in days |
Details
| • period date or period number | |
| • difference with the previous date using the | |
| • actual/actual day count | |
| • 30/360 day count | |
| • 30E/360 day count | |
| • actuarial day count | |
To toggle between dates and periods, click the header of the first column in the Details.
Related topics
| Date adjustments |
| Day count conventions |
| Year Fraction |