Finding the date on the 'nth' Monday in this Month in this Year

[agarwaldvk]

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

[Peo Sjoblom]

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" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>