Repeat Date

K

KLock

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
 
P

Pete_UK

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
 
T

Teethless mama

In B1: 10/1/2007
In B2: =(MOD(ROW(),3)=1)+C1
copy from B2 down as far as needed.
 
Top