List of weekend dates

[Miles Murakoshi]

How do I make a list of the dates of saturday and sunday
for the next five years?

I tried making a series but it seems as though Excel is
having a problem with the two consecutive days followed by
a five days.

 

[Peo Sjoblom]

In A1 put 9/6/03, in A2 put 9/7/03
in A3 put =A1+7

grab the lower right corner of A3 and drag copy down to A420

 

[JohnI in Brisbane]

Miles,

Put your first weekend date (i.e. Saturday or Sunday) in cell A2, and in A3
enter-

=IF(TEXT(A2,"ddd")="Sat",A2+1,IF(TEXT(A2,"ddd")="Sun",A2+6,"Error"))

Format this cell with your chosen dat format.

Drag the formula down as far as you need.

If you get the word "Error" appearing you have made a mistake.

regards,

JohnI

 

[StarTrek an beyond]

Cool JohnI

Wayne B

Miles,

Put your first weekend date (i.e. Saturday or Sunday) in cell A2, and in A3
enter-

=IF(TEXT(A2,"ddd")="Sat",A2+1,IF(TEXT(A2,"ddd")="Sun",A2+6,"Error"))

Format this cell with your chosen dat format.

Drag the formula down as far as you need.

If you get the word "Error" appearing you have made a mistake.

regards,

JohnI

 

[JohnI in Brisbane]

Thanx! ;-)

Cool JohnI

Wayne B