Check your formatting or Regional settings - 6/5/2006 could
mean either 6 May or 5 June. The answers you get are
all correct under suitable interpretations of the date.



Happybattles wrote:
Ok, finally got a number... but the number is 30.
Tried changing date to 5/5/2006 and it came up to 61...
Checked system time, its good.
The value should be zero... what else am i doing wrong?


Andrew Taylor wrote:
It's because Excel is formatting the result as a date.
Set the format to General and you will see the correct
value.

Andrew

Happybattles wrote:
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.