The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.
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...
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({Star...
This is amazing, thank you so much everyone.
Just putting this through it’s paces, and I’ve now managed to get the formula to work with a bit of tweaking in Google Calendar, but now facing 2 new challenges.
This formula will tell you if there is a we...