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

[Marq]

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

 

[ken2step]

In the cell you want the Day of week in just enter =D3 and format the cell to dddd.

 

[Marq]

excellent.....makes me wonder if i can do that instead of the choose month formula i have

Marq

 

[Aladin Akyurek]

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.