My employees receive bi-annual reviews. I know how to write a formula
to add six months to the hire date (in cell G2) to get the next review
date in cell G3. However, once the next review date is passed I want
the date in cell G3 to add another six months so that it always reflect
the next review date. I will then conditionally format the cell to
identify when I am two weeks or less from the next review date. I hope
this is clear enough. Any suggestions?