function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion

formula to count days between two dates but not count holidays or weekends

Hi Would it be possible to create a formula that would count all business days between 2 dates and not to include weekends and Banking holidays
Weekend is pretty easy to calcualte but no idea how to approach banking holidays.

Here is the list of dates i want to exclude form count:

Wednesday, January 1 New Year’s Day
Monday, January 20 Dr. Martin Luther King, Jr. Day
Monday, February 17 Presidents’ Day
Monday, May 26 Memorial Day
Friday, July 4 Independence Day
Monday, September 1 Labor Day
Tuesday, November 11 Veterans’ Day
Thursday, November 27 Thanksgiving Day
Thursday, December 25 Christmas Day

i would appreciate any help

thx in advance :)

Please try using the formula explained in the below help and training link:

This doesn't include the list of holidays you've mentioned in your post but you can add them in an IF statement.