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!
Bookmarks