Recurring Dates on a Calendar

Options

I am working on a team calendar that includes each team members flex day that might fall every other Tuesday and every other Friday. I found this amazing formula for the next Monday, but I would like to incorporate a condition for if the week is even or odd

For example, if the WEEKNUMBER is even, then pull the next Tuesday. If the WEEKNUMBER is odd, generate the next Friday.

Does anyone have any thoughts?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!