Choose Day formula..is there a way???

Marq

Well-known Member
Joined
Dec 13, 2004
Messages
914
Office Version
  1. 365
  2. 2007
Platform
  1. Windows
heres what I tried to do.....

In column D starting with cell D3 I have dates (i.e. 1-3-05; 1-17-05; etc)...the days are random throughout column D

I would like to have a formula off to the side, say in column N that would populate the actual day of the date in its cell in column D

for example...If D3 has 1-27-05 Id like N3 to have Thursday

I could then drag this formula down as far as I have dats in column D

ok....i tried using the "Choose Month formula, but replaced it with DAY but it does not work
here is what I have but not working:

=IF(D3>0,CHOOSE(DAYD3),"Monday","Tuesday","Wednesday","Thursday","Friday","Saturday","Sunday"),"")

I use this formula for choose month of whatever date is in column D and works perfect...I figured if I changed the word Month to Day, and changed the names of the months to the names of the days it would work...but it doesnt.

anyone?

Marq
 

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney

ken2step

Well-known Member
Joined
Jan 9, 2003
Messages
632
In the cell you want the Day of week in just enter =D3 and format the cell to dddd.
 

Marq

Well-known Member
Joined
Dec 13, 2004
Messages
914
Office Version
  1. 365
  2. 2007
Platform
  1. Windows
excellent.....makes me wonder if i can do that instead of the choose month formula i have

Marq
 

Aladin Akyurek

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,209
Marq said:
excellent.....makes me wonder if i can do that instead of the choose month formula i have

Marq

Sure...

=D3

Custom format the cell as mmm

or

=TEXT(D3,"mmm")

where D3 houses a true date.
 

Forum statistics

Threads
1,148,523
Messages
5,747,180
Members
424,068
Latest member
Salim khamis

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top