I want to be able to tell if a holiday is between two dates

[john_Box]

I want to be able to have someone put in two dates and have a list of dates that are holidays and then for a formula to tell me their is 1 or 2 or etc holidays between the two dates you picked. i cant figure it out.

[john_Box]

if date occurs during an array of days between to dates print "there is ‘X’ holidays during this time.

[ScottWorld]

The only way that you could do this with a native Airtable formula (i.e. without writing a custom JavaScript) is to use the WORKDAY_DIFF function.

The WORKDAY_DIFF function completely ignores weekends, but it returns the number of days between 2 dates, and you can optionally specify whether it should skip over holiday dates (that you manually specify) in between those 2 dates.

So you would use that function twice (potentially in 2 different formula fields):

1. The first time, use that function with no holidays specified.
2. The second time, use that function with holidays specified.

Then, compare the difference between those 2 formulas, and you will see how many holidays fall in between the dates.

Again, this ignores weekends, so if you need weekends included, then you’re out of luck here and will need to turn to a custom JavaScript.

Here is a list of holidays you can use:

U.S. Holidays for WORKDAY() and WORKDAY_DIFF() Show and tell

A silly little base that does one thing: It generates a string of ISO-formatted holiday dates as an input to WORKDAY() and WORKDAY_DIFF(). As published, it supports current U.S. federal holidays, with options to deselect three federal holidays (Martin Luther King’s Birthday, Columbus Day, and Veterans Day) some companies do not take off, as well as two non-holidays (Friday before Labor Day and Friday after Thanksgiving) many companies do. For holidays that fall on a specific day of the month (e.…

[john_Box]

how do you create workday_diff with no holidays specified ?

[ScottWorld]

The holidays section is optional, so you can just leave that part out.