List of weekend dates

  • Thread starter Thread starter Miles Murakoshi
  • Start date Start date
M

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.
 
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
 
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
 
Cool JohnI

Wayne B
JohnI in Brisbane said:
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
Click to expand...
 
Back
Top