|
Converting a date of birth into an age
in Microsoft Excel
To play this video you must have installed the free
Adobe
Flash Player, please click the link to install it if the video
below doesn't run.
Formula used in demonstration
|
-
=DATEDIF(A2,TODAY(),"Y")
-
=DATEDIF(A2,TODAY(),"M")
-
=DATEDIF(A2,TODAY(),"D")
-
=DATEDIF(A2,TODAY(),"YM")
-
=DATEDIF(A2,TODAY(),"MD")
-
=DATEDIF(A2,TODAY(),"YD")
-
=DATEDIF(A2,TODAY(),"Y")&" years "&DATEDIF(A2,TODAY(),"YM")&" months
"&DATEDIF(A2,TODAY(),"MD")&" days"
|
|
