excel, dates and days ...

  • Thread starter Thread starter Larry Levinson
  • Start date Start date
L

Larry Levinson

right now, at 5:30 p.m. ET, on dec. 21 according to God, man, and my
operating system,

=DAY(NOW()) shows 21

so how come

=TEXT(DAY(NOW()),"Dddd") shows up as `Saturday?'


tia ...


Larry Levinson
Talking up to the vocal ...
LLevinson*Bloomberg.net
(remove the star etc ....)
 
Hi
quite simple :-)
DAY(NOW())
returns 21. If this is interpreted as a date value it would be the
21-Jan-1900
(and this was a Saturday)

So use
=TEXT(NOW(),"Dddd")

or
=TEXT(TODAY(),"Dddd")

instead
 
Larry,

The DAY Function return the day of month, and to day is the 21st
of November. The "dddd" format specifier in the TEXT function
returns the full day name. So all is right in your world.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
I meant to add that the DAY function in your TEXT function
returns 21, the 21st day of Excel's 1/1/1900 based calendar,
which was a Saturday.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
Back
Top