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. 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?
10 Replies
- The formula in D2, copied down rows, is:
=EDATE(B2,
(C2="Good")*3+3) - The phrase “from the previous date” denotes that EDATE should be used instead of EOMONTH, which indicates “from the end of the month wherein the previous date pertains”.
Twifoo , sure, that shall be EDATE and sorry for the misprint
- 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.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?
