Hi, Struggling with this Nested IF formula. Maybe I need to use “Find”? Goal to automatically calculate deadline based on type of task. A) If it’s annual, biannual, quarterly or monthly then ADD the respective days to the creation date to produce th...

Hi! We are using this for property management. Have a table with each action/task. some are one-time but other occur monthly, quarterly, annually… etc. I want to add the completion date to the May Landscaping Record [which is quarterly] and have th...