WEEKDAY question on year

[mrjeep]

This is an easy one, but my brain just isn't working tonight!!

Here's the formula to show the day

=CHOOSE(WEEKDAY("1 Ja
2006"),"Sun","Mon","Tue","Wed","Thu","Fri","Sat")

Is there a way to have a seperate cell w/ the year (let's say A2) an
instead of 2006 in the formula to have = A2, so when you change th
year, it automatically updates each day?

Thank

 

[Ardus Petus]

=CHOOSE(WEEKDAY(DATE(A2,1,1)),"Sun","Mon","Tue","Wed","Thu","Fri","Sat")

HTH

 

[Bob Phillips]

=CHOOSE(WEEKDAY("1 Jan " &A2),"Sun","Mon","Tue","Wed","Thu","Fri","Sat")

but you could also do

=TEXT("1 Jan"&A2,"ddd")

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)