Change mm/dd/yy to Day

[Old Guy]

How would you have the mm/dd/yy in one cell and the actual day returned in
another?

 

[Gord Dibben]

Old Guy

=DAY(cellref) returns a day of the month number.

You can leave as is or Format to dddd to see Sunday, Monday etc.

Gord Dibben Excel MVP

On Tue, 12 Oct 2004 16:27:04 -0700, "Old Guy" <Old

 

[Old Guy]

Thanks for the help. If possible would you please elaborate on the dddd
thing? An example would be very helpful. Thanks again.

 

[Old Guy]

Gord,

Did the format thing but it returns the wrong day. Fomattted A9 with
mm/dd/yy, referred A10 to it using =DAY(A9) and formatted it with Custom
dddd. Gave a day but the wrong one. Where did I screw up?

Confused Old Guy

 

[Alex Delamain]

Not anything you did wrong - just a miscommunication!

If you follow Gord's reply to the letter the following happens:
The formula =day(cellref) returns the day of the month - ie 20/10/0
becomes 20. If you format this to "dddd" it returns friday when toda
is actually wednesday! This is because it is just looking at 20 and ha
lost the rest of the date.

to turn a date in cell A1 into the day of the week in B1 us
=text(a1,"dddd")

if you want the day of the week as a number use =weekday(a1,1) if you
week starts on sunday, or =weekday(a1,2) if it starts on monday

 

[JE McGimpsey]

See

http://www.mcgimpsey.com/excel/pennyoff.html

 

[Gord Dibben]

Thanks Alex

Old guy sent me an email and I admitted my error, but gave him no solution.

Hope he is sorted now.

Gord