software

Hello
I have a year in E1. In B4 I would like the date of the first Monday in May
in the year in E1. what formula can I use to return this?
Thanks!www.cpearson.com/excel/DateTimeWS.htm#NthDoW

--
Kind regards,

Niek Otten

quot;Sandyquot; gt; wrote in message
...
gt; Hello
gt; I have a year in E1. In B4 I would like the date of the first Monday in
gt; May
gt; in the year in E1. what formula can I use to return this?
gt; Thanks!
gt;

In B4

=DATE(E1,5,8)-WEEKDAY(DATE(E1,5,6))--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: www.excelforum.com/member.php...oamp;userid=30486
View this thread: www.excelforum.com/showthread...hreadid=520713