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....
- 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
- It is now manifest that we intended to suggest the same formula. I just avoided IF by using Boolean logic, which I noticed was your favorite. Incidentally, you might have unwittingly resorted to the plain IF, rather than the cryptic Boolean logic.
- 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?
