| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Calculating Date difference in 2 ways
Hi,
If in cell A1 I write -- = today() - date(2004,12,31) then the answer I get is a number ( let's say 14 or 15) But if in cell B1 If i write -- = C1 - D1 where C1 -- = Today() and D1 -- = date(2004,12,31), the answer I get is in date format (in excel's 1900 base year) Why is there a diference in formatting of results between the above 2 approaches. Regards, Hari India |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date updates from worksheet to chart & changes date to a date series! Help!! | Charts and Charting in Excel | |||
| how do i make a date change automatically if i change one before . | Excel Discussion (Misc queries) | |||
| Calculating time difference | Excel Discussion (Misc queries) | |||
| Date formula | Excel Discussion (Misc queries) | |||
| Problem with Date format from VBA code | Excel Discussion (Misc queries) | |||
Threaded Mode
