Hi!
=WEEKDAY(DATE(A1+ROW()-1,4,1),2)=6
This leads to incorrect results. ROW()-1 causes the
problem.
=WEEKDAY(DATE(A1,4,1),2)=6
Works just fine.
Biff
-----Original Message-----
Write in cells A1:A21 the year numbers 1970 till 1990.
In B1 write:
=WEEKDAY(DATE(A1+ROW()-1,4,1),2)=6
and copy down.
HTH,
Bernd
.
|