Example is 20/02/90, 20 is the date, 02 is the month and 90 is the year. How to calculate the age of the person now.
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
Calculating age through date of birth
0
Answers
0
=datedif(start date,end date, units)
Discussion
NOT GOOD
N00772 (rep: 2) Oct 21, '19 at 2:49 pm
N00772, your comment "NO GOOD" is rude in several counts.
Firstly, allcaps indicates shouting on forums. I fail to see why you should feel the need to shout at poor beepetark whose only mistake seems to be that he tried to help you.
Secondly, the DATDIFF fuunction does indeed enable the calculation of a person's age because that is calculated by comparing the date of his birth with the current date. So, if you have difficulty applying the logic to your particular need screaming "NO GOOD" at the top of your lungs is no adequate replacement for a better explanation of your question.
Or is it that you have a problem implementing? Is it that the formula you have created displays a number instead of a date?
Firstly, allcaps indicates shouting on forums. I fail to see why you should feel the need to shout at poor beepetark whose only mistake seems to be that he tried to help you.
Secondly, the DATDIFF fuunction does indeed enable the calculation of a person's age because that is calculated by comparing the date of his birth with the current date. So, if you have difficulty applying the logic to your particular need screaming "NO GOOD" at the top of your lungs is no adequate replacement for a better explanation of your question.
Or is it that you have a problem implementing? Is it that the formula you have created displays a number instead of a date?
Variatus (rep: 4889) Oct 22, '19 at 11:28 pm
I didnot get u sir
beepetark Oct 26, '19 at 2:04 pm
0
here is a formular I use
=" Age = "& DATEDIF(H16,D4,"y") &" Years "&DATEDIF(H16,D4,"ym") &" Months "&DATEDIF(H16,D4,"md") & " Days"/CODE]
The H16 is the date of birth the D4 is the date you need to know their age - Probably [CODE]Now()