Company holidays to calculate working days

We plan to use for leave requests in our company. We need to calculate the working days during the leave period request by excluding weekends and company holidays. We can exclude weekends but are stumped on how to exclude other holidays.

Hey @SThakkar1,

Would something like this work for you? :pray:

NETWORKDAYS({Date 1 }, {Date 2}, SPLIT({Holidays}, ","))

This function counts the start date as one day (e.g. Dec 20 - 24 = 5 days instead of 4), but you can tweak this by adding ‘-1’ at the end. This formula requires you to write all of the holidays in a formula column, like this: “2021/12/24, 2021/12/31”

Let me know your thoughts!