Example
Cell A1 contains 03/23/2020 at 06hr 21min
Cell B1 contains 21 Days 10hrs 46 mins
C1 = A1+B1. The result in C1 must include the date and the time of the addition. (A1+B1)
However, the resultant date in C1 needs to exclude dates that fall on weekends and Public Holidays, they are to be ignored. The result must only show weekday answers.
I have tried using the workday function, but I'm really struggling to get this working.
Any help would be very much appreciated.
Thanks
Ron
Cell A1 contains 03/23/2020 at 06hr 21min
Cell B1 contains 21 Days 10hrs 46 mins
C1 = A1+B1. The result in C1 must include the date and the time of the addition. (A1+B1)
However, the resultant date in C1 needs to exclude dates that fall on weekends and Public Holidays, they are to be ignored. The result must only show weekday answers.
I have tried using the workday function, but I'm really struggling to get this working.
Any help would be very much appreciated.
Thanks
Ron