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