Forum Discussion
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 a...
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")