Find First Monday in May

[Sandy]

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!

[Niek Otten]

http://www.cpearson.com/excel/DateTimeWS.htm#NthDoW

--
Kind regards,

Niek Otten

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

[daddylonglegs]

In B4

=DATE(E1,5,8)-WEEKDAY(DATE(E1,5,6))