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

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How do I get the week in month from a date? (https://www.excelbanter.com/excel-worksheet-functions/236681-how-do-i-get-week-month-date.html)

Oke

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

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

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?

Ron Rosenfeld

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

On Mon, 13 Jul 2009 02:05:01 -0700, Oke wrote:

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

All times are GMT +1. The time now is 07:26 AM.