Here's my formula:

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

where C1 = the year 2006

B1 has the month Jan and I want to input that into my formula, so when
I change the month, it automatically will change my formula.

I tried =CHOOSE(WEEKDAY("1 $B$1 "
&$C$1),"Sun","Mon","Tue","Wed","Thu","Fri","Sat ")

B1 = Jan
C1 = 2006

But this isn't working. Are there any suggestions?

Thanks,


--
fastballfreddy
------------------------------------------------------------------------
fastballfreddy's Profile: http://www.excelforum.com/member.php...o&userid=33986
View this thread: http://www.excelforum.com/showthread...hreadid=539943