calculate age in excel
how do I calculate a person's age using Excel & today's date?
I have had several attempts & all have failed, returning figures such as 7 years 13 months! or 7 years & 12 months
Windows Forum
how do I calculate a person's age using Excel & today's date?
I have had several attempts & all have failed, returning figures such as 7 years 13 months! or 7 years & 12 months
by syscokid
Here's an example using VBA to calculate the difference between two dates:
by mrwreckit
by larry h.
If cell A1 contains the Date of Birth in some other cell type:
=TEXT(TRUNC((NOW( )-A1) / 365.25),0)&" years and "&TEXT(MOD(NOW( )-A1,365.25)/30,0) & " months."
by mrwreckit
by mmccaskill69
by mrwreckit
YES
thank you, I have been trying to do this for a long time
This discussion is closed to new replies.
Sort by Trending