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