Date and years calculation

[maniarasan]

Hi,

Consider a cell value (i.e date of birth) is 04/06/1990 (mm/dd/yyyy)
and another cell value (i.e date when completed graduation) is
06/06/2008.

I want the formula or excel program to find the actual years and
months after graduation to till date(sys date).

Please help me on this.


Thanks

 

[Pete_UK]

You can use the DATEDIF function for this. As this is not included in
XL Help, I refer you to Chip Pearson's excellent description on his
website:

http://www.cpearson.com/excel/datedif.aspx

Hope this helps.

Pete

 

[Don Guillett Excel MVP]

Hi,

Consider a cell value (i.e date of birth) is 04/06/1990 (mm/dd/yyyy)
and another cell value (i.e date when completed graduation) is
06/06/2008.

I want the formula or excel program to find the actual years and
months after graduation to till date(sys date).

Please help me on this.

Thanks

Where a4 is the earlier date
=DATEDIF(A4,B4,"y")&" yrs "&DATEDIF(A4,B4,"ym")&" mths"
Don Guillett Excel MVP