Calculate date based on review type and date of last review.

alys

I have a sheet to track 90 day and annual performance reviews. I would like to create a formula for the 'Date of Next Review' column. I am trying to calculate if 'Review Type' is 'Annual Review', add 365 days to 'Date of Last Review'. If 'Review Type' is '90 day review', add 90 days to 'Date of Last Review'.

EvanShortreed

Good Afternoon,

Here are the steps:

1. Input your dates in the date of last review

2. Put this formula in the date of next review: =IF([Review Type]@row = "Annual Review", [Date of Last Review]@row + 365,
IF([Review Type]@row = "90 day review", [Date of Last Review]@row + 90,
""))

If you need more help moving forward, let us know at Entheos how we can assist.

https://www.entheosstudio.com/

alys

That worked, thank you!