Dear Friends.
We all love automated results.. A simple formulas can make our
work so easy with full of accuracy.
Today I am going to tell you about a
formula which you will not find in the inbuilt dictionary of MS Excel. This
formula is simple and useful in cases when you want to know the correct age of
a person in Years, Months & Days.
|
Birth
date :
|
23-Jan-84
|
|||
|
Years
lived :
|
29
|
=DATEDIF(C8,TODAY(),"y")
|
||
|
and the
months :
|
1
|
=DATEDIF(C8,TODAY(),"ym")
|
||
|
and the
days :
|
30
|
=DATEDIF(C8,TODAY(),"md")
|
||
I have attached a file for your reference and download.
Click here to download the excel file.
No comments:
Post a Comment