How to output sequence of dates NOT listed in table?

1

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:

2

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

image
image1604×978 140 KB

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!

3 Likes
3

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
4

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