Dates

Giganews Newsgroups
Subject: Dates
Posted by:  lsmft (lsmft.276omy_1146579301.0849@excelforum-nospam.com)
Date: Tue, 2 May 2006

I have two dates: 04/16/04, and 06/20/05.
I want to get the difference of time between the two in mm/dd/yy.
I subtracted 04/16/04 from 06/20/05 and got the answer of 03/05/01,
which would mean 3 months, 5 days, 1 year.
Shouldn't it be correctly stated as 2 months, 4 days, 1 year?
What have I done wrong?

--
lsmft
------------------------------------------------------------------------
lsmft's Profile:http://www.excelforum.com/member.php?action=getinfo&userid=30678
View this thread:http://www.excelforum.com/showthread.php?threadid=538058

Replies