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'.
Tags:
Answers
-
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.
-
That worked, thank you!
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives