Gordon1963
New Member
- Joined
- Oct 18, 2017
- Messages
- 18
I'm trying to do follow-ups by calculate 5 business days between two columns and does not want to include holidays for ex:
Entered Date 5 day FU
12/17/2018 12/24/2018 (did not include Christmas and weekend)
12/24/2018 1/2/2019 (did not include New Years or weekend)
I'm looking for a formula that will calculates 5 business day from the Entered Date and if a holiday falls within the week, don't include holiday within the formula. There will be 100's of entered date
Entered Date 5 day FU
12/17/2018 12/24/2018 (did not include Christmas and weekend)
12/24/2018 1/2/2019 (did not include New Years or weekend)
I'm looking for a formula that will calculates 5 business day from the Entered Date and if a holiday falls within the week, don't include holiday within the formula. There will be 100's of entered date