Find an age of a person based on his/her date of birth :-
To find an age of a person, we need to subtract current date ( NOW() function) with his/her birth date. It brings the result in numerical values. Format it with TEXT function to convert the numeric values in years, months and days .
Formula :
=TEXT((NOW()-A2)&"","yy"" years ""m"" months ""dd"" days """)
See example in below print shot:-
Thank you !!
To find an age of a person, we need to subtract current date ( NOW() function) with his/her birth date. It brings the result in numerical values. Format it with TEXT function to convert the numeric values in years, months and days .
Formula :
=TEXT((NOW()-A2)&"","yy"" years ""m"" months ""dd"" days """)
See example in below print shot:-
Thank you !!
No comments:
Post a Comment