| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error with Calculating date difference using TODAY()
Cell E3 contains a date like this: 6/5/06
Cell E4 is supposed to show how many days have passed since that date... so here's my formula: =TODAY()-E3 The result is 1/20/1900 What am I doing wrong exactly? I'm going to take a bunch of entries and average out the number of days that have passed from each... but I can't seem to get an integer... i just get an obscure date. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating Age NOT as of today but as of a date in the future or | Excel Discussion (Misc queries) | |||
| difference of date/time only calculating workingdays/hours | Excel Worksheet Functions | |||
| error calculating negativ difference time values | Excel Programming | |||
| Calculating Difference Between Start Date & Time And End Date & Ti | Excel Discussion (Misc queries) | |||
| Calculating Date difference in 2 ways | Excel Discussion (Misc queries) | |||
Threaded Mode
