Calculate Date Employee turns 18

Brian_C

Can anyone provide a formula that calculates when an employee turns 18, based on a DOB (date of birth) cell.  I've reviewed the forum and found formulas that return an age, but we need a date so we can set up a notifier email to alert payroll for some HR requirements. 

Paul Newcome

You should be able to use something like this...

 

=DATE(YEAR([Date of Birth]@row) + 18, MONTH([Date of Birth]@row), DAY([Date of Birth]@row))