In A1 thru A56 enter:

=DATE(1952+ROW(),11,13)

In B1 enter:

=TEXT(A1,"DDD") and copy down thru B56

Finally =COUNTIF(B:B,"Fri") will display 8
--
Gary''s Student - gsnu200823


"Bill" wrote:

How do I calculate how many times a given date 11/13 occured on a Friday
since 1953 to present?