Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() 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 |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() =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 |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
2 Nesting questions | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |