Working with series of dates

Working with series of dates

When the start date of a series is at the end of a month (e.g., November 30 or February 28), the events in that series will all fall on the last day of each month. If you want events to fall on a particular date (e.g., November 30 start date with payments on the 30th of each month), separate these events from the rest of the events in a series. Then start a series for the remaining payments beginning on a date that is not a month-end (e.g., December 30).

TValue automatically assigns dates to centuries based on a two-digit year. Years from 60 through 99 become 1960 through 1999. Years from 00 through 59 become 2000 through 2059. To enter a date beyond 2059, type the whole year (e.g., 2076) instead of just the last two digits. The End Date of the last cash flow line can be as late as the year 2400.