Novice here...

mrs peel · Apr 4th, 2002, 03:55 PM

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)!

lenze · Apr 4th, 2002, 03:58 PM

To get you started, have a look at the WEEKDAY function. Then you might look at the CHOOSE function.

Barrie Davidson · Apr 4th, 2002, 04:01 PM

Quote:

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,

anno · Apr 4th, 2002, 04:02 PM

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

anno · Apr 4th, 2002, 04:03 PM

sorry barry - didn't see your post when i dove in

Barrie Davidson · Apr 4th, 2002, 04:04 PM

Quote:

On 2002-04-04 15:03, anno wrote:
sorry barry - didn't see your post when i dove in

Anno, are you sure you didn't copy my answer?

_________________

Barrie Davidson
My Excel Web Page

[ This Message was edited by: Barrie Davidson on 2002-04-04 15:04 ]

mrs peel · Apr 4th, 2002, 04:08 PM

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!

anno · Apr 4th, 2002, 04:09 PM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 4th, 2002, 03:55 PM	#1
mrs peel New Member Join Date: Apr 2002 Posts: 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)!

Apr 4th, 2002, 03:58 PM	#2
lenze MrExcel MVP Join Date: Feb 2002 Location: Helena, MT Posts: 13,690	To get you started, have a look at the WEEKDAY function. Then you might look at the CHOOSE function.

Apr 4th, 2002, 04:02 PM	#4
anno Board Regular Join Date: Feb 2002 Posts: 202	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

Apr 4th, 2002, 04:03 PM	#5
anno Board Regular Join Date: Feb 2002 Posts: 202	sorry barry - didn't see your post when i dove in

Apr 4th, 2002, 04:08 PM	#7
mrs peel New Member Join Date: Apr 2002 Posts: 2	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!

Apr 4th, 2002, 04:09 PM	#8
anno Board Regular Join Date: Feb 2002 Posts: 202	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