Date and years calculation

  • Thread starter Thread starter maniarasan
  • Start date Start date
M

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
 
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
Click to expand...

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