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

=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

Hi!

Try this:

Enter the month number in B1:

B1 = 1
C1 = 2006

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

Biff

"fastballfreddy"
<fastballfreddy.27i2tm_1147110901.7708@excelforu m-nospam.com wrote in
message news:fastballfreddy.27i2tm_1147110901.7708@excelfo rum-nospam.com...

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

No need to use that formula at all, assuming that you want the weekday of
the 1st of each month and year you put in B1 and C1 you can use

=TEXT(B1&" "&C1,"ddd")



--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com


"fastballfreddy"
<fastballfreddy.27i2tm_1147110901.7708@excelforu m-nospam.com wrote in
message news:fastballfreddy.27i2tm_1147110901.7708@excelfo rum-nospam.com...

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

hi!

try this!

in E1:

=CHOOSE(WEEKDAY((A1&"/"&B1&"/"&C1)),"Sun"'"Mon","Tue","Wed","Thu","Fri","Sa t")

where A1 having the day
B1 having the month &
C1 having the year

-via135

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,


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