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

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

On Jun 11, 8:57*am, maniarasan <maniarasa...@gmail.com> wrote:
> 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

On Jun 11, 2:57*am, maniarasan <maniarasa...@gmail.com> wrote:
> 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