weekdays

  • Thread starter Thread starter Tom
  • Start date Start date
T

Tom

Hi all,
on one cell i have a date in mm/dd/yy format.
on the cell below i used the weekday function, but the days represented as
numbers.
How can I convert 2 to monday, 3 to tuesday etc..

Thanks,
Tom
 
Hi Andy!

Format date as ddd only works if date is on or after 1-March-1900
<vbg>

Format of date as ddd to get correct DoW is a result of a lucky
accident that inserted a Leap Year in 1900 when there wasn't one.
Similarly, WEEKDAY(A1) returns incorrectly during 1-Jan-1900 to (sic)
29-Feb-1900.

But I'm still looking for a case where this is important. I think I
might be a bit late!

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Hi Tom!

Always pleased to help. But it was Andy who did the work. My comment was
more an explanation of why formatting WEEKDAY as ddd will return the correct
DoW.

--
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Thanks, works great
Tom

Norman Harker said:
Hi Andy!

Format date as ddd only works if date is on or after 1-March-1900
<vbg>

Format of date as ddd to get correct DoW is a result of a lucky
accident that inserted a Leap Year in 1900 when there wasn't one.
Similarly, WEEKDAY(A1) returns incorrectly during 1-Jan-1900 to (sic)
29-Feb-1900.

But I'm still looking for a case where this is important. I think I
might be a bit late!

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
Click to expand...
 
I meant to thank everyone :-)
Tom


Norman Harker said:
Hi Tom!

Always pleased to help. But it was Andy who did the work. My comment was
more an explanation of why formatting WEEKDAY as ddd will return the correct
DoW.

--
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
Click to expand...
 
Back
Top