Repeat Date

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a list of 3 departements. I want to drag the same date for the 3
departments then change the date to the next day for the same departments.
How can I setup the drag function to change the date every 4th space for a
month.

dept 1 10/1/2007
dept 2 10/1/2007
dept 3 10/1/2007
dept 1 10/2/2007
dept 2 10/2/2007
dept 3 10/2/2007
dept 1 10/3/2007
 
Do you mean that you have your 3 departments already entered in column
A, and you want a date to be copied down column B to increment every 3
rows?

If so, enter your starting date in B1 and put this formula in B2:

=IF(MOD(ROW()+2,3)=0,B1+1,B1)

Format the cell as a date, then copy the formula down.

Hope this helps.

Pete
 
Back
Top