WEEKDAY question on year
 

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

Here's the formula to show the day

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

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

Thanks


--
mrjeep
------------------------------------------------------------------------
mrjeep's Profile: http://www.excelforum.com/member.php...o&userid=34001
View this thread: http://www.excelforum.com/showthread...hreadid=538339

WEEKDAY question on year
 

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

HTH
--
AP

"mrjeep" a écrit dans
le message de news: ...

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

Here's the formula to show the day

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

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

Thanks


--
mrjeep
------------------------------------------------------------------------
mrjeep's Profile:
http://www.excelforum.com/member.php...o&userid=34001
View this thread: http://www.excelforum.com/showthread...hreadid=538339

WEEKDAY question on year
 

=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)

"mrjeep" wrote in
message ...

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

Here's the formula to show the day

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

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

Thanks


--
mrjeep
------------------------------------------------------------------------
mrjeep's Profile:
http://www.excelforum.com/member.php...o&userid=34001
View this thread: http://www.excelforum.com/showthread...hreadid=538339