| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
=today()-3/7/2009 = 4?
The difference between those two dates is indeed 125 days. The number 125 as
a date means Thursday, May 03, 1900. Thursday is the 4th day, that's why you get 4 if you format as d. What result did you want? -- Kind regards, Niek Otten Microsoft MVP - Excel "dindigul" wrote in message ... As given above, I tried the function I get 4 when I use custom cell format as "d", whereas if I don't specify "d" it shows 125. What am I doing wrong? Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how can subtact or add Week 07/2009 in one column & Week 10/2009 . | Excel Worksheet Functions | |||
| 2009 Employee Calendar | Excel Discussion (Misc queries) | |||
| How create 365 labels for 2009? Example: Monday, Jan. 4, 2009 | Excel Discussion (Misc queries) | |||
| How do I determine who will be age 55 by 12/31/2007 and 6/30/2009? | Excel Worksheet Functions | |||
|
=IF(OR(TODAY() |
Excel Discussion (Misc queries) | |||
Threaded Mode
