You need to sign in to do that
Don't have an account?
cldave
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 :)
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:
https://help.salesforce.com/HTViewSolution?id=000004526
This doesn't include the list of holidays you've mentioned in your post but you can add them in an IF statement.