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
This is a discussion on Formula to find age problem within the Excel Questions forums, part of the Question Forums category; Hi, can anyone tell me why this formula isn't working? Its meant to find someone's age as of a certain ...
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)
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
Alan Sidman
Win 10--Office 2013
Click below for a white paper on Data Base Design
http://sbuweb.tcu.edu/bjones/20263/A...sDB_Design.pdf
Hi,
I'm not an expert so I cannot help you with this formula, sorry.
I know this doesn't answer your problem, but...
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
A reply is not only helpful to others, but polite to those who have provided a solution!!
To post sample data go here....
HtmlMaker
Excel Genie
Use Borders
Upload a Sample File
Visit here for some EXCELlent videos...
Make sure that the cell is formatted as General then re-enter the formula.
HTH, Peter
Please test any code on a copy of your workbook.
Like this thread? Share it with others