Excel - How much time has passed?

Asked By BK on 23-Dec-07 09:43 AM
Using Excel 2003

I am using the following formula to calculate how much time has passed since
a particular event.

=DATEDIF(D2,NOW(),"y")

This returns the passage of time in full years.  I am stumped trying to get
the result in years and months such as "3 years 6 months."  Can anyone help?


replied on 23-Dec-07 09:55 AM
Check out http://support.microsoft.com/kb/290190/en-us , particular event
being a birthday.

John
Bob Phillips replied on 23-Dec-07 10:01 AM
=DATEDIF(D2,TODAY(),"y")&" years "&DATEDIF(D2,TODAY(),"YM")&" months"

--
---
HTH

Bob


(there is no email, no snail mail, but somewhere should be gmail in my addy)
Sandy Mann replied on 23-Dec-07 10:13 AM
For months use:

=DATEDIF(D2,TODAY(),"ym")

Returns the number of odd months left over after the number of years.  It
can be combined into one cell as in:

=DATEDIF(D2,TODAY(),"y")&" years "&DATEDIF(D2,TODAY(),"ym")&" Months"

If you want to avoid it saying "   1 Months" instead of "   1 Month" then
use:

=DATEDIF(D2,TODAY(),"y")&" year &"&IF(DATEDIF(D2,TODAY(),"y")<>1,"s ","


--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

sandymann2@mailinator.com
Replace @mailinator.com with @tiscali.co.uk
BK replied on 23-Dec-07 10:04 PM
Thanks so much.  This does the job.
BK replied on 23-Dec-07 10:04 PM
Thanks so much.  This does the job.
Sandy Mann replied on 24-Dec-07 07:51 AM
You're very welcome.  Thanks for the feedback'

--

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

sandymann2@mailinator.com
Replace @mailinator.com with @tiscali.co.uk
Previous Excel Discussion:  Is it possible to make all cells in a column have the same formula?