Auto show date for 1st Monday in January

[JamesT1]

Hi Guys,,

I'm trying to find the calculation which will automatically have the date for the first Monday in January to show

e.g. Cell A1 input 2010 Cell A2 would show 04/01/2010

Cell A1 input 2011 Cell A2 would show 03/01/2011

etc

Thanks in advance

[darkyam]

Try =("1/1/"&A1)+MOD(9-WEEKDAY("1/1/"&A1+0),7)

[daddylonglegs]

Try

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

[JamesT1]

Guys

Your a pair of lifesavers,,, very much appreciated

Thanks

JT