G
Guest
How would you have the mm/dd/yy in one cell and the actual day returned in
another?
another?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
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
=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
G
Guest
Thanks for the help. If possible would you please elaborate on the dddd
thing? An example would be very helpful. Thanks again.
thing? An example would be very helpful. Thanks again.
G
Guest
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
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
A
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
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
J
JE McGimpsey
G
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
Old guy sent me an email and I admitted my error, but gave him no solution.
Hope he is sorted now.
Gord