Calculate next employee review date from hire date

[Albie27]

Hello all - I have a spreadsheet that lists employees by date of hire. We have a review cycle that occurs at 90 days, 180 days, 365 days, and then thereafter every 6 months. I would like to create a formula to show what the employee’s next upcoming review date is. Any help is much appreciated!!

 

[Albie27]

Thank you both so much for your thoughtful responses! Both work for the most part, however @jatkw formula allows for future hire dates whereas @Fluff formula stops working with a future hire date. Much appreciated!!!

 

[jtakw]

You're welcome.