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 frequency
• 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