Fill Series-Dates

[Blair]

I'm curious if its possible to use the fill series to have dates in a column
alternate between 4 and 3 days at a time. For example if I wanted to use
today's date as a start and the next date would be 4 days later, then the
next date after that would be 3 days later, then 4 days later, 3 days later,
etc...

May 26
May 29 (3 days later)
June 2 (4 days later)
June 5 (3 days later)
June 9 (4 days later)
etc....

I'm know it would probably be just as easy to enter the date at the time I'm
using that row, but it's more for curiosity sake and quite frankly, it would
be convienent. Just wondering.

Thanks in advance for any info

 

[Frank Kabel]

Hi
in A1 enter your starting date
in B1 enter
=A1+3+MOD(ROW(),2)
and copy this down

 

[CLR]

Try this..........

Enter your first 3 dates by hand..........then highlight them, along with
all the other cells in that column you wish to populate with the
trend............then do Edit > Fill > Series > Columns > Linear > Trend >
OK

Vaya con Dios,
Chuck, CABGx3