Microsoft KB Archive/42294

Incrementing Dates by Month or Year PSS ID Number: Q42294 Article last modified on 03-09-1989 PSS database name: D_MPlan

3.x 4.00 4.01

MS-DOS

Summary:

To increment dates by year or month, use the following formulas, where R[-1]C is the date reference to increment.

To increment a date by year, use the following formula:

DATE(YEAR(R[-1]C)+1,MONTH(R[-1]C),DAY(R[-1]C))

To increment a date by month, use the following formula:

DATE(YEAR(R[-1]C),MONTH(R[-1]C)+1,DAY(R[-1]C))

These formulas can be used to produce a column of dates that increment by month or year.

Copyright Microsoft Corporation 1989.