First Monday of Year

**Medusa** · 04-30-2009, 04:36 PM

I am trying to write a function that will display the first Monday of the year based on the user entry.

For example, if I enter;

5/1/2011, It should produce 1/3/2011...
12/31/2012, it should produce 1/2/2012...

etc...

I am sure that this is very easy, however I am having a tough time with this one. Thanks in advance.

**daddylonglegs** · 04-30-2009, 04:43 PM

If the input date is in cell A1 then this formula will give the first Monday of the year

=DATE(YEAR(A1),1,1)-WEEKDAY(DATE(YEAR(A1),1,6))

**Medusa** · 04-30-2009, 04:56 PM

Originally Posted by daddylonglegs

If the input date is in cell A1 then this formula will give the first Monday of the year

=DATE(YEAR(A1),1,1)-WEEKDAY(DATE(YEAR(A1),1,6))

This returns the last Monday of the previous year... Is the easiest fix for this to "+7" the equation?...

Thanks!

**daddylonglegs** · 04-30-2009, 05:14 PM

Sorry, I had it working but amended the formula erroneously at the end, as you say you could add 7 but it should really be like this

=DATE(YEAR(A1),1,8)-WEEKDAY(DATE(YEAR(A1),1,6))