Formula to find age problem

Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: Formula to find age problem

  1. #1
    Board Regular
    Join Date
    Mar 2009
    Posts
    469
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default 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. #2
    Board Regular alansidman's Avatar
    Join Date
    Feb 2007
    Location
    Steamboat Springs
    Posts
    4,018
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default 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
    Alan Sidman
    Win 10--Office 2016

    Click below for a white paper on Data Base Design
    http://r937.com/relational.html



  3. #3
    Board Regular Akashwani's Avatar
    Join Date
    Mar 2009
    Posts
    2,900
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Formula to find age problem

    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...

  4. #4
    MrExcel MVP VoG's Avatar
    Join Date
    Jun 2002
    Location
    127.0.0.1
    Posts
    63,651
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    2 Thread(s)

    Default Re: Formula to find age problem

    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.

  5. #5
    Board Regular
    Join Date
    Mar 2009
    Posts
    469
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Formula to find age problem

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

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com