Date Sequence Formula or Code

[ststern45]

I have a list of dates in the following sequence:

I will insert a line a row 10 and drag a formula up so that I keep the current sequence.

(I want Mon-11-07005 in cell A10)
Sun-11-06-05 Cell A11
Sat-11-05-05 Cell A12
Fri-11-04-05
Fri-11-04-05
Thu-11-03-05
Thu-11-03-05
Wed-11-02-05
Wed-11-02-05
Tue-11-01-05
Tue-11-01-05
Mon-10-31-05
Mon-10-31-05
Sun-10-30-05
Sat-10-29-05
Fri-10-28-05
Fri-10-28-05

So the sequence should be Mon, Mon, Tue, Tue, Wed, Wed, Thur, Thur, Fri, Fri, Sat, Sun, Mon, Mon etc
So the next 2 days would be Tue Tue

Thank you in advance,

Steve

 

[IML]

=A22+7

 

[ststern45]

Some things are so obvious!!!

That's what you call a major DUHHHHHH on my part.

Thanks,

Steve