How to check if a date is between 2 date fields

I have a statutory vacation dates table. and I also have a vacations/leave calendar table.
I’d like to know if there is a way to check if a statutory day is in the Start/end date of the vacations/leave calendar.
Statutory Day - New Years : Jan 1st 2021
Vacation Request: December 28th 2020 to Jan 3rd 2021
I’d like to check if , and display in a column, if New Years is in the vacation requests date range,
so I can also exclude the Stat day from vacation days calculation

Dear @Mohamed_Hamad1 ,

I have the feeling that this post is the direction to go

Credit to @Pch

You can use NetWorkingDays() formula for calculating vacation days.

If there is the table ‘StatutoryDayTable’ which contains statutory days on column ‘date’,
you can use the following formula

NetWorkingDays(vacationStartDate, vacationEndDate,

The limitation of this formula is that it excludes all weekends(Saturday and Sunday). So in the situation that it needs to include Saturday or Sunday as working days, you can’t use this formula.