Microsoft Office Tutorials and References

In Depth Information

**Generating a Series of Dates**

The following examples assume that you entered the first date of the series into cell A1 and the

formula into cell A2. You can then copy this formula down the column as many times as needed.

To generate a series of dates separated by seven days, use this formula:

=A1+7

To generate a series of dates separated by one month, use this formula:

=DATE(YEAR(A1),MONTH(A1)+1,DAY(A1))

To generate a series of dates separated by one year, use this formula:

=DATE(YEAR(A1)+1,MONTH(A1),DAY(A1))

To generate a series of weekdays only (no Saturdays or Sundays), use the following formula. It

assumes that the date in cell A1 isn’t a weekend day:

=IF(WEEKDAY(A1)=6,A1+3,A1+1)

This formula returns a date serial number, so you’ll need to format the cells to display dates.