Skip to main content

Currently, I have to make another table to track dates, holidays and weekends.  This is a real pain.  It would be nice if there were a setting somewhere either at the table or base level where I could select work weekends, yes or no, etc.  Right now this is a really drawback.

If you want a kind of complex solution for the weekend element at least, you can use a formula to datetime format a date into it's days of the week (Monday, Tuesday, etc), then either build a filter that excludes Sat/Sun or add another formula (or probably just layer your datetime format formula) that defines those two as "weekend". 

Holidays are harder, but there are Google Calendar/iCal files that you could set up an automation to import. 


Reply