How do I get the week in month from a 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?
 
S

Stefi

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

Regards,
Stefi

„Oke†ezt írta:
 
R

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top