Calculate Date Column dependent on number column
I am looking for assistance writing a formula for one of my sheets. I have the following columns:
6 Month F/u Date
12 Month F/u Date
What I am looking to do is have the 6 follow up dates calculate from the visit date only if the screening score is above 9. If it is 9 or below, I would like the 6 month field to remain blank and the 12 month field to populate.
I will admit that formulas are not my strong suit. I have tried this a few different ways and keep getting error messages. Any assistance is greatly appreciated! Thank you!
Help Article Resources
Check out the Formula Handbook template!