Forum Discussion
Vanessa_Aceti
Apr 16, 2019Copper Contributor
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....
Twifoo
Apr 17, 2019Silver Contributor
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”.
SergeiBaklan
Apr 17, 2019Diamond Contributor
Twifoo , sure, that shall be EDATE and sorry for the misprint
- TwifooApr 17, 2019Silver ContributorIt 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.
- SergeiBaklanApr 17, 2019Diamond Contributor
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.
- TwifooApr 17, 2019Silver ContributorWe share the same preference to Boolean logic, although it may seem cryptic to the uninitiated. I always use it, regardless of the preference of others, but I must admit that I sometimes inadvertently use the instantly conceivable IF, AND, and OR.