I want to do this thing, but I have no idea where to start or what type of formulas to try:
I'm tracking evaluations in my company
Column E is the type of evaluation: Initial F, and Initial E.
Column G is the date their evaluation process was initiated
Column H is the date their evaluation process closes out.
People designated "Initial F" in column E have a close out date (Column H) that is 60 days after their initiation date (Column G)
People designated "Initial E" in column E have a close out date (Column H) that is 45 days after their initiation date (Column G)
I want column H to automatically generate a date that is respectively, 45 or 60 days after the date in column G based on the condition in column E.
