Dates

  • Thread starter Thread starter Jon
  • Start date Start date
J

Jon

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

Thanks,
Jon
 
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)
 
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)
 
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)
 
Back
Top