View Single Post
  #5   Report Post  
Daniel.M
 
Posts: n/a
Default

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.