How to output sequence of dates NOT listed in table?

I’ve hit a brick wall on this :face_with_head_bandage:

Trying to output a list of dates within a set time frame that are NOT contained in my calendar of events.

My objective is to easily identify dates of availability. I also want to control days of the week shown (I’ve set up checkbox controls for Mon, Tue, Wed, etc.)—for example, I might use this to see a list of Fridays I’m available between 11/1/23 and 12/31/23.

I’ve got calendar sync set up, and also my controls. I’m new to the Sequence function though, and I don’t know how to filter my sequence of dates by 1) day of week, and 2) dates not contained in my calendar table.

Many thanks in advance. Here’s my doc:

Here you go amiga!

No worries about hitting that brick wall - glad you reached our for help! Feel free to look into the doc to confirm this is what you are looking for

Heres a quick explanation of the formula I wrote

The key to this is understanding the following Formulas:

Each one of those links shows some thorough documentation, examples, and practice activities for the formulas. Let me know if you need any more help!


Wow, this is fantastic Scott, thanks a million!!! (think I had the placement of “.not” wrong ? among other things…)

I’m a big fan of your work, by the way! :clap: Your YouTube channel is the clearest, most useful, and most concise Coda content I’ve found—that gmail automation video really took one of my projects to the next level :rocket::pray:

1 Like

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