Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
excel, dates and days ...
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 ....) |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
excel, dates and days ...
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 -- Regards Frank Kabel Frankfurt, Germany "Larry Levinson" schrieb im Newsbeitrag ... 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 ....) |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
excel, dates and days ...
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 "Larry Levinson" wrote in message ... 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 ....) |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
excel, dates and days ...
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 "Chip Pearson" wrote in message ... 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 "Larry Levinson" wrote in message ... 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 ....) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calc days between two dates and exclude leap year days | Excel Worksheet Functions | |||
Conditional Formatting Dates calculating 10 days and 30 days from a certain date | Excel Worksheet Functions | |||
Excel adding days to dates | Excel Discussion (Misc queries) | |||
How to calc # of days between two dates in YYYYMMDD in EXCEL. | Excel Discussion (Misc queries) | |||
Calculating # of busn days, not just calendar days, between 2 dates? | Excel Programming |