View Single Post
  #4   Report Post  
Biff
 
Posts: n/a
Default

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


.