Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

How to calculate PTO minus weekends and holidays

100 0
Showing results for 
Search instead for 
Did you mean: 

I am working to build an Airtable base that allows employees to request paid time off (PTO) from their managers via Airtable form. The form requests the start date and end date of PTO. Ideally, from there, I’d have a field that populates the number of days PTO amounts to MINUS weekends and company holidays. I’ve used a workday_diff formula, but I have to update the holidays listed each year manually. Is there a way to use the workday_diff formula that automatically updates the holiday dates each year so they don’t have to be manually updated?

0 Replies 0