Return day of week for 1 January

D

dalymjl

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
 
D

dalymjl

Kevin said:
=TEXT(DATE(a1,1,1),"dddd")

--
Kevin Vaughn


:


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
Click to expand...

Thanks Kevin,

That worked fine.

Would you know how I could test the year entered in A1 to return TRU
if the year is a leap year and FALSE if not. I can do this if a ful
date is entered using = IF(MONTH(DATE(YEAR(A1),2,29))=2,TRUE,FALSE).
However I can't get it to work if A1 contains only the year
 
D

daddylonglegs

Just replace YEAR(A1) in your formula with A1 - also the IF function is
redundant so this suffices

=MONTH(DATE(A1,2,29))=2
 
Top