Results 1 to 5 of 5

Formula to find age problem

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

  1. #1
    Board Regular
    Join Date
    Mar 2009
    Posts
    469

    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
    2,740

    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 7--Office XP, 2007, 2010

    Be Kind--Use Code Tags. Highlight your code and click on the # sign at the top of the thread window.


  3. #3
    Board Regular Akashwani's Avatar
    Join Date
    Mar 2009
    Posts
    2,894

    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
    VoG
    VoG is offline
    MrExcel MVP
    Moderator
    VoG's Avatar
    Join Date
    Jun 2002
    Location
    127.0.0.1
    Posts
    63,537

    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

    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

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