Dates

[Jon]

Is there a formula for calculation the number on Mondays
in January, and so on for each month. Similarly for
Fridays?

Thanks,
Jon

 

[JulieD]

Hi Jon

Check out -

http://www.cpearson.com/excel/DateTimeWS.htm

Chip has an article there called "number of mondays in a period" about 3/4
through the page.

Hope this helps
Cheers
JulieD

 

[Bob Phillips]

Jon,

One way

=
INT((DAY(DATE(YEAR(A1),MONTH(A1)+1,1)-WEEKDAY(DATE(YEAR(A1),MONTH(A1)+1,6))
) + 6 ) / 7 )

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Bob Phillips]

BTW, Friday would be

=INT((DAY(DATE(YEAR(A1),MONTH(A1)+1,1)-WEEKDAY(DATE(YEAR(A1),MONTH(A1)+1,2))
) + 6 ) / 7 )

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Bob Phillips]

Or better still, I have dug this formula up from my archives that I first
saw posted by Daniel M

=4+(DAY(A1-DAY(A1)+35)<WEEKDAY(A1-DAY(A1)-wdn))

where wdn is the week day number, 0 = Mon,. 1 = Tues, etc.


--

HTH

RP
(remove nothere from the email address if mailing direct)