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.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives