Novice here...

mrs peel

New Member
Joined
Apr 3, 2002
Messages
2
Maybe I'm daft, but here's my no-such-thing-as-a-stupid question:

If I enter a date (d/m/y) in a cell, can I automatically display (in a different cell) the DAY of that date?

Told you I was a novice.

Cheers (and thanks)!
 

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.
To get you started, have a look at the WEEKDAY function. Then you might look at the CHOOSE function.
 
Upvote 0
On 2002-04-04 14:55, mrs peel wrote:
Maybe I'm daft, but here's my no-such-thing-as-a-stupid question:

If I enter a date (d/m/y) in a cell, can I automatically display (in a different cell) the DAY of that date?

Told you I was a novice.

Cheers (and thanks)!
Just use a formula and then custom format your cell. For example, if your date is in cell A1, use =A1. Custom format your cell with the formula to "dddd" (minus the quotation marks). To custom format, select Format|Cells and choose "Custom" in the category box in the Number tab. Put "dddd" in the Type box.

Regards,
 
Upvote 0
mrs peel
assuming your date is in A1, in the other cell enter =A1 and custom format this cell as 'dddd'. to do this go to the format menu, select cells, number tab, select custom and type in dddd in the 'Type' box
 
Upvote 0
Brilliant.

Here's what worked (a combination of the fine advice here, and a wee bit of tweaking from the Help file):

=TEXT(B11, "dddd")

Where B11 contains the date.

Much thanks.

Cheers!
 
Upvote 0
barrie
i thought the same thing when i read your post, but the time stamp defeats me there :)
i guess great minds think alike...
have a good one
 
Upvote 0

Forum statistics

Threads
1,213,560
Messages
6,114,304
Members
448,564
Latest member
ED38

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
Back
Top