| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Finding the date on the 'nth' Monday in this Month in this Year
Hi Everybody If I have a need to find out the date on say the 1st Sunday of July 2006 or for that matter, the 'nth' say Monday in a specified month in a specified year, is there a way I can find it out using front end Excel? Best regards Deepak Agarwal -- agarwaldvk ------------------------------------------------------------------------ agarwaldvk's Profile: http://www.excelforum.com/member.php...o&userid=11345 View this thread: http://www.excelforum.com/showthread...hreadid=533563 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Finding the date on the 'nth' Monday in this Month in this Year
Taken straight from the date function master Daniel Maher ,
" =DATE(YR,Mth,1+7*Nth)-WEEKDAY(DATE(YR,Mth,8-DOW)) For the second Friday of Mar 2003: YR= 2003 Mth= 3 DOW= 6 ' cause Sunday =1, Monday =2, ..., Saturday = 7 Nth= 2 When Nth=5, you need to do a test if the specific month has 5 DOW." -- Regards, Peo Sjoblom http://nwexcelsolutions.com "agarwaldvk" wrote in message ... Hi Everybody If I have a need to find out the date on say the 1st Sunday of July 2006 or for that matter, the 'nth' say Monday in a specified month in a specified year, is there a way I can find it out using front end Excel? Best regards Deepak Agarwal -- agarwaldvk ------------------------------------------------------------------------ agarwaldvk's Profile: http://www.excelforum.com/member.php...o&userid=11345 View this thread: http://www.excelforum.com/showthread...hreadid=533563 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| a Month to Date and Year TD page in one sheet changing each day? | Excel Discussion (Misc queries) | |||
| add month to date | Excel Worksheet Functions | |||
| Finding people born in a given month or after a given year | Excel Worksheet Functions | |||
| Finding min and max date of a given month | Excel Worksheet Functions | |||
| Lookup the month in a date string 01/03/05 | Excel Worksheet Functions | |||
Hybrid Mode
