Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Repeat Date
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Repeat Date
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 On Oct 10, 3:28 pm, KLock wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Repeat Date
In B1: 10/1/2007
In B2: =(MOD(ROW(),3)=1)+C1 copy from B2 down as far as needed. "KLock" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
repeat first row at the top of page? | New Users to Excel | |||
how do i repeat paste | Excel Discussion (Misc queries) | |||
how to repeat rows at the bottom while using the rows repeat at to | Setting up and Configuration of Excel | |||
Title Cut Off if Rows to Repeat & Columns to Repeat are Both Selec | Excel Discussion (Misc queries) | |||
Don't want to repeat a selection | Excel Discussion (Misc queries) |