#1   Report Post  
Posted to microsoft.public.excel.misc
fastballfreddy
 
Posts: n/a
Default Weekday Formula


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   Report Post  
Posted to microsoft.public.excel.misc
Bryan Hessey
 
Posts: n/a
Default Weekday Formula


=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   Report Post  
Posted to microsoft.public.excel.misc
Biff
 
Posts: n/a
Default Weekday Formula

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   Report Post  
Posted to microsoft.public.excel.misc
Peo Sjoblom
 
Posts: n/a
Default Weekday Formula

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   Report Post  
Posted to microsoft.public.excel.misc
via135
 
Posts: n/a
Default Weekday Formula


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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Dynamic Range with unused formula messing up x axis on dynamic graph [email protected] Charts and Charting in Excel 2 February 2nd 06 09:02 PM
2 Nesting questions Starchaser Excel Worksheet Functions 7 January 20th 06 07:53 PM
Formula Problem - interrupted by #VALUE! in other cells!? Ted Excel Worksheet Functions 17 November 25th 05 06:18 PM
Formula checking multiple worksheets sonic-the-mouse Excel Worksheet Functions 2 June 5th 05 04:28 AM
Match / Vlookup within an Array formula Hari Prasadh Excel Discussion (Misc queries) 3 February 3rd 05 05:37 PM


All times are GMT +1. The time now is 06:26 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"