XL FORMULA FOCUS: Find end of probation period using EDATE

So you’ve got a new employee, and you want to know when their probation period is over? The EDATE function is really straight forward.

=EDATE(Start_date,Months)

So type in “=EDATE(“, click on the cell that contains their start date, type a comma, then enter the number of months. 3 months? 6 months? Type a 3 or a 6 or whatever it is. Then close your brackets “)” and press enter.

Done.

RELATED: If you need to calculate length of service, you may want to look here.

One thought on “XL FORMULA FOCUS: Find end of probation period using EDATE”

Leave a Reply

Your email address will not be published. Required fields are marked *