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. 

​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 initiatedColumn 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.   Read More

​