Hey, I am trying to create a feature in the application were a user can pick start date and end date from the Honeycode calendar but what I wanted is that when selecting the date it should exclude the Saturdays, Sundays and a list of holidays as well.
As you can see in the below Screenshot, one can select a start date and end date, and duration for their leave is auto-populated in No. of days section. Same start & end date means the user has taken 1 day leave.
So, I want to apply a formula on No.of days section(duration) which will exclude the Saturdays - Sundays and a list of holidays as well.
I came across the WEEKDAY() function but couldn't figure out how to use it?