Formula to find age problem

Thanks:  0
Likes:  0

# Thread: Formula to find age problem

1. ## Formula to find age problem

Hi, can anyone tell me why this formula isn't working? Its meant to find someone's age as of a certain date (N1) based on their date of birth (M4). All it's doing when I enter the formula is leaving the entire formula text in the cell....it's not even trying to calculate. HELP! Thanks!

=IF(ISBLANK(M4),"",INT((N1-M4)/365.25)

2. ## Re: Formula to find age problem

Are you using 2007 and do you have your settings to show the formula turned on or off?

In 2007, it is on the Formula tab and located under Auditing.

Alan

3. ## Re: Formula to find age problem

Hi,

I'm not an expert so I cannot help you with this formula, sorry.

I use this with Todays date in A1 and the date to be entered in A4.....

=IF(A4="","","You are " & TEXT(DATEDIF(A4, A1, "Y"), "0") & " years, " &TEXT(DATEDIF(A4, A1, "YM"), "0") & " months and " & TEXT(DATEDIF(A4, A1, "MD"), "0") & " days old.")

I hope that helps.

Good luck.

Ak

4. ## Re: Formula to find age problem

Make sure that the cell is formatted as General then re-enter the formula.

5. ## Re: Formula to find age problem

Originally Posted by VoG
Make sure that the cell is formatted as General then re-enter the formula.
Duh....that was it.....thank you

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•