Check if record is on, or spans a weekend

[Max_Spielbichle]

Hi Everyone,
I’ve got a table that pulls Google Calendar events for my team into Airtable. It’s there to build an interface that breaks the events down and gives summaries as to how many days are spent On Site, Working from Home, in the Office etc…

I need to find a way to be able to filter out, or mark with a checkbox, the records that happen on, or span a weekend. Google Calendar only brings in start and end dates of events.

Any pointers would be fantastic. I’m quite an experienced Airtable user, but have no experience of coding but willing to try.

Thanks!

[Max_Spielbichle]

Quick update on this;

I’ve worked around it with this formula for Saturday:

ROUNDDOWN((1+(DATETIME_DIFF({End},{Start},'days')-(6-WEEKDAY({Start})))/7),0)

And this formula for Sunday:

ROUNDDOWN((1+(DATETIME_DIFF({End},{Start},'days')-(5-WEEKDAY({Start})))/7),0)

Then I had another simple SUM formula field to add them to give me the number of weekend days worked in the event’s time period.

Credit to another user who’s post I now cannot find, but if I do I’ll link it here.

Thanks for the help everyone!

[Matt_DeGrand]

Thanks for pulling this together! Was exactly what I was looking for.