# 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?

• ✭✭✭✭✭✭
Options

Can you maybe share the formula and some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@workbold.com)

Be safe and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

SMARTSHEET EXPERT CONSULTANT & PARTNER

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

• Options

Here is the formula i found in another thread to calculate an upcoming day of the week:

=IF(WEEKDAY(Today@row) = 1, Today@row - (WEEKDAY(Today@row) - 10), Today@row - (WEEKDAY(Today@row) - 6) + 7)

Also, here is a screenshot of the very basic grid where I'm testing the formula:

• ✭✭✭✭✭✭
Options

I hope you're well and safe!

Excuse the late response.

Crazy times and I missed coming back to you.

Have you solved it, or do you still need help?

Happy New Year & Stay safe!

SMARTSHEET EXPERT CONSULTANT & PARTNER

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!