Hi Ron,
With some date in the month in A1:
=4+(DAY(A1-DAY(A1)+1-WEEKDAY(A1-DAY(A1+5))+35)7)
will give the number of Fridays in a month.
Thanks to Daniel M.
Thanks for the credit.
Here's an even shorter version:
=4+(DAY(A1-DAY(A1)+35)<WEEKDAY(A1-DAY(A1)-DOW))
DOW: 1:Monday 7:Sunday
Regards,
Daniel M.
|