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

[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?

 

[Stefi]

Given a date being in E1, try this:
=WEEKNUM(E1,2)-WEEKNUM(DATE(YEAR(E1),MONTH(E1),0))

Regards,
Stefi

„Oke†ezt írta:

 

[Ron Rosenfeld]

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?

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