Converting all dates in a period to the first day of a following quarter

I am trying to set up a reminder to do something on the first day of the second quarter after an event. So, for example, said event happens on February 6 (or January 27, or March 30, etc.), the reminder triggers on July 1. Likewise, if said event happens on October 20, the reminder triggers on April 1. I’m familiar with switch statements, but there has to be an easier way than writing out a switch for every day in a year (plus I also need to repeat the reminder for the third and fourth quarters, so that would be 3 times!) Hope that makes sense. Thanks!

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.