Thread
:
Calculating the number of Fridays in a month
View Single Post
#
1
Ron Rosenfeld
Posts: n/a
On Wed, 2 Mar 2005 10:21:20 -0500, "Daniel.M"
wrote:
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
Definitely a keeper!
--ron
Reply With Quote