Home |
Search |
Today's Posts |
#1
|
|||
|
|||
HOW DO I SET UP REPEATING DATES IN EXCEL?
i am trying to set up a series of dates in cells that will show four days
consecutively and then skip the next four days and run in a continual pattern for the entire year. for example: i want the first four cells to read 1/1/05, 1/2/05, 1/3/05, 1/4/05 and the next four to read 1/9/05, 1/10/05, 1/11/05, 1/12/05 and so on. can anyone help? |
#2
|
|||
|
|||
See response to your other post. Please don't post the same question to
multiple groups. On Thu, 3 Feb 2005 15:33:04 -0800, "tpapd754" wrote: i am trying to set up a series of dates in cells that will show four days consecutively and then skip the next four days and run in a continual pattern for the entire year. for example: i want the first four cells to read 1/1/05, 1/2/05, 1/3/05, 1/4/05 and the next four to read 1/9/05, 1/10/05, 1/11/05, 1/12/05 and so on. can anyone help? |
#3
|
|||
|
|||
In A1 put 1/1/05
A2 put =A1+1 copy A2 down through A4. in A5 put =A1+8 copy this down as far as you'd like. "tpapd754" wrote in message ... i am trying to set up a series of dates in cells that will show four days consecutively and then skip the next four days and run in a continual pattern for the entire year. for example: i want the first four cells to read 1/1/05, 1/2/05, 1/3/05, 1/4/05 and the next four to read 1/9/05, 1/10/05, 1/11/05, 1/12/05 and so on. can anyone help? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Why does Excel Copy and Paste change dates from the original when. | Excel Discussion (Misc queries) | |||
Entering dates in Excel 2002 | Excel Discussion (Misc queries) | |||
Can I get email alerts when dates in excel are nearing? | Excel Discussion (Misc queries) | |||
micosoft excel dates entered but changed to sequencial numbers ho. | Excel Worksheet Functions |