You can calculate a persons age based on their birthday and todays date. |
||||||||||
The calculation
uses the DATEDIF() function.
|
||||||||||
The
DATEDIF() is not documented in Excel 5, 7 or 97, but it is in 2000.
|
||||||||||
(Makes
you wonder what else Microsoft forgot to tell us!)
|
||||||||||
Birth
date :
|
29-Apr-73
|
|||||||||
Years
lived :
|
38
|
=DATEDIF(C8,TODAY(),"y")
|
||||||||
and the
months :
|
4
|
=DATEDIF(C8,TODAY(),"ym")
|
||||||||
and the
days :
|
27
|
=DATEDIF(C8,TODAY(),"md")
|
||||||||
You can
put this all together in one calculation, which creates a text version.
|
||||||||||
Age is 38 Years, 4 Months and 27 Days
|
||||||||||
="Age is
"&DATEDIF(C8,TODAY(),"y")&" Years,
"&DATEDIF(C8,TODAY(),"ym")&" Months and
"&DATEDIF(C8,TODAY(),"md")&" Days"
|
||||||||||
Another
way to calculate age
|
||||||||||
This
method gives you an age which may potentially have decimal places
representing the months.
|
||||||||||
If the
age is 20.5, the .5 represents 6 months.
|
||||||||||
Birth
date :
|
1-Jan-60
|
|||||||||
Age is :
|
51.73
|
=(TODAY()-C23)/365.25
|
||||||||
Welcome to Easy Web Tips! We’re here to simplify navigating the digital world with beginner-friendly tutorials on essential tools and online platforms. From setting up Google accounts to mastering Gmail, organizing files in Google Drive, and even learning quick video editing tips, our step-by-step guides help you become more productive and secure online.
Showing posts with label AGE CALCULATION. Show all posts
Showing posts with label AGE CALCULATION. Show all posts
Monday, September 19, 2011
AGE CALCULATION Formula
You can calculate a persons age based on their birthday and todays date.
Subscribe to:
Posts (Atom)