+ Reply to Thread
Results 1 to 2 of 2

Calculating age of child between dates

  1. #1
    Registered User
    Join Date
    01-22-2016
    Location
    Canada
    MS-Off Ver
    365
    Posts
    41

    Calculating age of child between dates

    Hi,
    I know calculating dates in Excel can be confusing and I'm stuck on this piece of logic. Maybe the issue is my brain is till in vacation mode after three weeks off.

    I am looking for a formula that will help me run my childcare centre more effectively as the rate charged is based on the age of the child.

    The report date entered by the user is cell A2. The child?s date of birth is entered in cell B9. If it helps, the date format for both are "MM/DD/YYYY" (6/18/2016) for June 18, 2016.

    If a child is 71 months of age or younger as of a report date entered in A2, then the child?s parents are charged rate 'A'
    If a child is 72 months of age of older as of a report date entered in A2, then the child?s parents are charged rate 'B'.
    However, if the child birthdate means they turn 72 months of age after July 1, then the parents are still charged rate 'A'.

    I have tried IF/THEN/ELSE, nested IF/THEN formulas, but keep getting stuck. Ugh!

    Any help for this likely easy problem will be greatly appreciated!

  2. #2
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.83 for Mac MS 365
    Posts
    8,480

    Re: Calculating age of child between dates

    you could use datedif for that... =IF(DATEDIF(B9,A2,"M")<72,"A","B")
    if you are concerned about blanks then... =IF(OR(B9="",A2=""),"",IF(DATEDIF(B9,A2,"M")<72,"A","B"))
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci

+ 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. Help calculating approvals for a specific item based on dates or no dates
    By TDFrench in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-16-2021, 09:20 AM
  2. Replies: 1
    Last Post: 09-23-2018, 09:29 PM
  3. [SOLVED] Parent Child relationship issue: Get parent ID for child
    By masterl1983 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 08-28-2018, 07:35 AM
  4. Formula calculating start/end dates using today and Blank if no dates
    By Italstal33 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-29-2017, 05:17 AM
  5. Calculating weeks/days old if child is less than 1 month or 1 week old.
    By sharpmel in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-17-2013, 04:00 PM
  6. Replies: 6
    Last Post: 12-03-2012, 05:41 PM
  7. Calculating the Average Growth of a Child
    By ExcelTip in forum Tips and Tutorials
    Replies: 0
    Last Post: 08-29-2005, 07:36 AM

Tags for this Thread

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