How do I get the week in month from a date?

  • Thread starter Thread starter Oke
  • Start date Start date
O

Oke

I am searching for a formula to provide the week of the month given a date.
For example 13, July 2009 is the 2nd Monday in July 2009. Does anyone know a
formula/function I can use?
 
Given a date being in E1, try this:
=WEEKNUM(E1,2)-WEEKNUM(DATE(YEAR(E1),MONTH(E1),0))

Regards,
Stefi

„Oke†ezt írta:
 
I am searching for a formula to provide the week of the month given a date.
For example 13, July 2009 is the 2nd Monday in July 2009. Does anyone know a
formula/function I can use?
Click to expand...

How are you defining the first day of the first week in a given month?
--ron
 
Back
Top