Forum Discussion

EMMAGOUGH's avatar
EMMAGOUGH
Copper Contributor
Jul 18, 2023

Under 18/Under 21 Forumla Help

Hi,

 

I have a Date of Birth column (DOB) with peoples birthday's in and I would like the next column to tell me "yes" or "no" if this person will be under 18 before 1 September 2023.

 

I would also like another column to do the same but to tell me if they will be over 21 before 1 September 2023. 

 

I've tried searching for examples but I can't seem to find exactly what I need.

 

Please could someone advise a formula? Thank you in advance!


Warm Regards,

Emma

excel
Formulas and Functions
  • flexyourdata's avatar
    flexyourdata
    Iron Contributor
    Jul 18, 2023

    EMMAGOUGH 

     

     

    Recommend adding a column with the Age:

    =DATEDIF(B3,$C$2,"y")

     

    Then calculating the "Yes"/"No" columns:

     

    =IF(C3<18,"Yes","No")

=IF(C3>=21,"Yes","No")

     

Resources