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.
 
Search JabSto ::




Custom Search