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?