software

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 regardsDeepak Agarwal--
agarwaldvk
------------------------------------------------------------------------
agarwaldvk's Profile: www.excelforum.com/member.php...oamp;userid=11345
View this thread: www.excelforum.com/showthread...hreadid=533563Taken straight from the date function master Daniel Maher ,

quot;
=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= 2When Nth=5, you need to do a test if the specific month has 5 DOW.quot;--

Regards,

Peo Sjoblom

nwexcelsolutions.com
quot;agarwaldvkquot; gt; wrote
in message ...
gt;
gt; Hi Everybody
gt;
gt; If I have a need to find out the date on say the 1st Sunday of July
gt; 2006 or for that matter, the 'nth' say Monday in a specified month in a
gt; specified year, is there a way I can find it out using front end Excel?
gt;
gt;
gt; Best regards
gt;
gt;
gt; Deepak Agarwal
gt;
gt;
gt; --
gt; agarwaldvk
gt; ------------------------------------------------------------------------
gt; agarwaldvk's Profile:
gt; www.excelforum.com/member.php...oamp;userid=11345
gt; View this thread: www.excelforum.com/showthread...hreadid=533563
gt;