Forum Discussion
What IF formula help
Good afternoon, I am trying to set up a formula that calculates a date based on a cells value. For Example: Name Date Reviewed Rating Date of Next Review J....
SergeiBaklan
I'd like the generated date to be based on a result in the "Rating" column. Not the previous date. The previous date is a starting point for the generated future date.
Hope that makes sense.
I'd like the generated date to be based on a result in the "Rating" column. Not the previous date. The previous date is a starting point for the generated future date.
Hope that makes sense.
What the formula do it takes previous date and adds to it 6 months if the rating is Good or 3 month otherwise. What do you mean under "Not the previous date" - we add months to TODAY or what?