Calculate Year/Month

eyemgod

Board Regular
Joined
May 29, 2003
Messages
60
Hello everyone,

I dont have something too complicated here I think. But i am not able to figure it out.

I have date in two columns and need to calculate so the result is how many year and month in between the two dates.

example:
Column A - 23 Aug 2004
Column B - 23 Oct 2006
Column C (result) - 2 years 2 month

Thanks,

Andre
 

Some videos you may like

Excel Facts

Easy bullets in Excel
If you have a numeric keypad, press Alt+7 on numeric keypad to type a bullet in Excel.

tmcfadden

Board Regular
Joined
Aug 17, 2005
Messages
151
Well, a really simple implementation would be:
Code:
=YEAR(B1)-YEAR(A1) & " years, " & MONTH(B1)-MONTH(A1) & " months"

That might not always work for you though. For example, 1-DEC-06 & 1-JAN-07.

-Tim
 

Watch MrExcel Video

Forum statistics

Threads
1,114,041
Messages
5,545,685
Members
410,697
Latest member
srishtijain0708
Top