# 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```