HOW DO I SET UP A SERIES OF 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?

Assuming the first date is in A3, put this formula in A4:

=IF(MOD(ROW(),4)=MOD(ROW($A$3),4),A3+5,A3+1)

The $A$3 must refer to the cell containing the first date.

On Thu, 3 Feb 2005 15:29:07 -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?