| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VBA - Record date of month as day of week | Excel Discussion (Misc queries) | |||
| how to insert month date year and day of week | Excel Discussion (Misc queries) | |||
| how to insert month date year and day of week | New Users to Excel | |||
| how to insert month date year and day of week | Excel Worksheet Functions | |||
| Excel: Is there a way to calculate the date as week of month? | Excel Discussion (Misc queries) | |||
Linear Mode
