Find First Monday in May

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Monday closest to today's date? 6
Calculate the first monday of a month in the future or in the past 3
split range address into individual cell addresses 4
Can selection from text drop-down dictate value in another cell 3
I give up, trying to sum with non numeric cells. 2
Determine year over year date for comparison 3
incrementing a date that the user has entered? 4
Set add function ignore #N/A 1

Back
Top