I am trying to take a later date and subtract from it an earlier date to
determine the time in between. (07/11/06)-(04/14/05)=(03/28/01)
1Y 3M 28D is not correct. What am I missing?

See this:

http://www.cpearson.com/Excel/datedif.aspx

--
Biff
Microsoft Excel MVP


"Newbie" wrote in message
...
I am trying to take a later date and subtract from it an earlier date to
determine the time in between. (07/11/06)-(04/14/05)=(03/28/01)
1Y 3M 28D is not correct. What am I missing?

You're assuming that 3/28/01 means 1Y 3M 28D...

XL stores dates as integer offsets from a base date (12/31/1899 in
Windows default 1900 date system, 1/1/1904 in the Mac default 1904 date
system), with 1 = 1 day.

Format your result cell as General and you'll see that the result is 453
days. Format it as a date, though, and XL incorrectly determines that
453 days after 12/31/1899 is 3/28/1901.

If you want years, months, and days, you can use DATEDIF:

http://cpearson.com/excel/datedif.aspx

Be aware, however, that months are impossible to generally and
consistently define algorithmically.

In article ,
Newbie wrote:

I am trying to take a later date and subtract from it an earlier date to
determine the time in between. (07/11/06)-(04/14/05)=(03/28/01)
1Y 3M 28D is not correct. What am I missing?

Can you combine "y" "m" "d" in the formula to get 2 yrs 3 months and 5 days?

"T. Valko" wrote:

See this:

http://www.cpearson.com/Excel/datedif.aspx

--
Biff
Microsoft Excel MVP


"Newbie" wrote in message
...
I am trying to take a later date and subtract from it an earlier date to
determine the time in between. (07/11/06)-(04/14/05)=(03/28/01)
1Y 3M 28D is not correct. What am I missing?