=CHOOSE(WEEKDAY("1 " & B1 & " "
&$C$1),"Sun","Mon","Tue","Wed","Thu","Fri","Sat ")
--
fastballfreddy Wrote:
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,
--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile:
http://www.excelforum.com/member.php...o&userid=21059
View this thread:
http://www.excelforum.com/showthread...hreadid=539943