Apr 16 2019 12:57 PM - edited Apr 16 2019 01:00 PM
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. Smith April 15 2019 Good (6 months from april 15 2019)
P. Smith April 15 2019 Poor (3 months from april 15 2019)
S. Smith April 15 2019 New (3 months from april 15 2019)
I would like to set up a formula that based on a "Good", "Poor", or "New" value, it generates a date that is either 3 months from the previous date or 6 months from the previous date.
Is this possible?
Apr 16 2019 01:08 PM
Apr 16 2019 01:18 PM
Apr 16 2019 01:25 PM
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?
Apr 16 2019 10:28 PM
Apr 17 2019 10:58 AM
Apr 17 2019 11:13 AM
@Twifoo , sure, that shall be EDATE and sorry for the misprint
Apr 17 2019 11:40 AM
Apr 17 2019 11:49 AM
@Twifoo , yes, I personally prefer * and + instead of AND and OR, but I don't push other people to do the same - depends on situation.
Apr 17 2019 11:59 AM
Apr 17 2019 01:21 PM
That's the same story as to use only shortcuts or only mouse; use tables or avoid tables; use VLOOKUP or INDEX/MATCH, etc. Doesn't matter, all works. Depends on personality and concrete situations.