Change mm/dd/yy to Day

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
Thanks for the help. If possible would you please elaborate on the dddd
thing? An example would be very helpful. Thanks again.
 
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
 
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
 
Thanks Alex

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

Hope he is sorted now.

Gord
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

change DD/MM/YY to MM/DD/YY 6
Expiration date based on 5 years and Birth month,day ... 4
How to enter a date in DD-MM-YYYY format 2
Date enters wrong #'s 1
Converting MM/DD/YYYY into just MM/DD and Sorting 1
Formatting today() 6
Date format 2
Need mm-dd-yy for date but helpless 2

Back
Top