Recurring Dates on a Calendar

Liane Giles LeBlanc

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?

Andrée Starå

Hi @Liane Giles LeBlanc

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

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Liane Giles LeBlanc

Hi @Andrée Starå,

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:

Andrée Starå

@Liane Giles LeBlanc

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!