Forum Discussion
age in months calculation
I need to calculate if a person is 20 months old today or will be 20 months old this year based on a dob. I've tried with some datedif but I can't figure out how I would calculate this. If I do ...
=YEAR(EDATE(dob,20))=2022
so EDATE will offset dob (date of birth) by 20 months so basically the date they turn 20 months old and then check if that YEAR() is this year (2022) or substitute a different reference as needed.
so EDATE will offset dob (date of birth) by 20 months so basically the date they turn 20 months old and then check if that YEAR() is this year (2022) or substitute a different reference as needed.