Hi,
Given a date, how can I add a number of days to it including/counting given date as well, but exclude weekends (Fri,Sat) and Holidays? e.g. given Aug 26, 2020 (Wednesday) and adding 4 days will result in Aug 31, 2020 (Monday).
Plus: IF Holiday(s) fall on weekend then shift number of holidays those fell on weekends.
e.g. given Aug 26, 2020 (Wednesday) and adding 4 days will result in Aug 31, 2020 (Monday). IF Aug 29, 2020 (Saturday) is holiday, then the result will be Oct 01, 2020 (Tuesday) rather than Aug 31, 2020 (Monday).
Regards,
Bookmarks