Count how many months/years have passed?

**famico78** · 05-13-2009, 08:08 AM

I have a column that contains issue dates, A1= 01/01/2008. And the second column contains a start date, B1= 02/01/2009. What I want to do is count how many months/years have passed from the date in A1.

Please help!

**vandanavai** · 05-13-2009, 08:13 AM

Hello

Enter following formula in C1
=DATEDIF(A1,B1,"m") This will give u months
=DATEDIF(A1,B1,"y") This will give u years

**oldchippy** · 05-13-2009, 08:26 AM

Or maybe

=DATEDIF(A1,B1,"y") & " years, " & DATEDIF(A1,B1,"ym") & " months"

**broro183** · 05-13-2009, 08:29 AM

hi,

To add to Vandanavai's answer, Chip's below page provides an explanation & further examples of the DateDif function: http://www.cpearson.com/excel/datedif.aspx

hth
Rob

**DemRulesDoe** · 08-24-2017, 05:36 PM

Similar problem with an added step. I need to return how many months have passed to the end of the year, since a start date. So let's say my A1 is 02/01/2017 and the answer is 11 months. Then for A2, the date is a year later, 02/01/2018 and I need to return 23 months and so on with an offset end date of 4/30/2028 returning 123 months. Any ideas? I need to automate this so if I change a constant 123 months, it will return the proper values every year.

**bakerman2** · 08-24-2017, 10:04 PM

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.