Sorry Posted in wrong forum

I want to find the day of the week on which the 1st Jan falls in the
year I input. For example: in A1 all I want to enter is a year e.g.
2006. In B1 I want a formula that will return the value SUNDAY. I can
get the formula to work if I enter 1/1/06 in A1 but I just want to
enter the year. I tried using Concatenate to add 1/1/ to the value in
A1 but couldn't get excel to recognise the concatenation as a date. Any
ideas?

thanks

mjd


--
dalymjl