# 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

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a \$25,000 loan, 5% annual interest, 60 month loan.
In the cell you want the Day of week in just enter =D3 and format the cell to dddd.

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

Marq

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
5
Views
262
Replies
3
Views
106
Replies
24
Views
347
Replies
4
Views
971
Replies
4
Views
270

### Forum statistics

Threads
1,221,051
Messages
6,157,626
Members
451,426
Latest member
VinnyDoesntKnowExcelCode

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

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