Hello everyone. I am new to this forum. I tried to search on this but did not get any results. I have followed the help instructions on on excel but I keep getting "The formula you typed contains an error".
Here is what the help screen says to enter:
To calculate a person (or anything else) age you basically subtract his date of birth from today’s date. However which date functions to use depends on the amount of precision and the output format you want.
3. If we want his age in years and months, then we can use a formula like this one:
=INT((TODAY()-A1)/365.25) & ” years and ” & INT(MOD((TODAY()-A1)/365.25;1)*12) & ” months”
The output of this formula will be as follows:
40 years and 2 months.
I change A1 to G3 because that is where I the birth date.
I'm sure that this is something simple that I am just over looking.
Thanks for any help.
car24winsagain
Bookmarks