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

#### Marq

##### Well-known Member
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

To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.

#### ken2step

##### Well-known Member
In the cell you want the Day of week in just enter =D3 and format the cell to dddd.

#### Marq

##### Well-known Member
excellent.....makes me wonder if i can do that instead of the choose month formula i have

Marq

##### MrExcel MVP
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.

Replies
3
Views
171
Replies
2
Views
83
Replies
3
Views
239
Replies
5
Views
129
Replies
5
Views
160

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

1,152,480
Messages
5,770,337
Members
425,612
Latest member
martinijr

### 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.

### Which adblocker are you using?

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

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