How to calculate PTO minus weekends and holidays

394 0
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

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