+ Reply to Thread
Results 1 to 5 of 5

Formula to calculate Age

  1. #1
    Valued Forum Contributor
    Join Date
    01-18-2007
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    4,434

    Formula to calculate Age

    Hello:

    Please refer to attached file.
    I need to formula in column F to calculate Age in full Integer in column F based on DOB in column D.

    Also need conditional formula in column G to give Membership as follows.
    If value in column D is "FALSE" OR value in column F is greater then 18 then value in column G will be $100 otherwise zero

    Let me know if you have any questions.
    Thanks.
    Riz
    Attached Files Attached Files

  2. #2
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,211

    Re: Formula to calculate Age

    Please try F2 =DATEDIF(E2,TODAY(),"y")
    G2 =IF(OR(NOT(D2),F2>18),100,0)

  3. #3
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    365
    Posts
    6,266

    Re: Formula to calculate Age

    Try these:

    F2 =DATEDIF(E2,TODAY(),"y")
    G2 =IF(OR(D2=FALSE,F2>18),100,0)

    Edit: Looks like I was beat to it!

  4. #4
    Valued Forum Contributor
    Join Date
    01-18-2007
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    4,434

    Re: Formula to calculate Age

    Hello:

    Thanks to both..

    Riz

  5. #5
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    365
    Posts
    6,266

    Re: Formula to calculate Age

    Glad we could help. Thanks for the rep!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 1
    Last Post: 01-07-2018, 10:30 AM
  2. Macro to replace formula with result when formula calculate
    By sumit dey in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-26-2016, 06:03 AM
  3. Replies: 1
    Last Post: 01-11-2016, 02:31 PM
  4. Replies: 1
    Last Post: 01-08-2015, 07:02 PM
  5. Replies: 2
    Last Post: 05-13-2014, 01:18 PM
  6. Replies: 3
    Last Post: 03-28-2013, 12:41 PM
  7. Replies: 1
    Last Post: 02-02-2013, 02:28 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1