Adding 21 days 10hr 46 min to 03/23/2020

[2_RJJ]

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

 

[jasonb75]

Try something like this. Note that excel does not know public holidays by default. They are not the same in all countries and some vary by year. You will need to provide the formula with a list of public holiday dates. These are assumed to be in D1:D10 in the formula, but can be placed anywhere.

=WORKDAY(A1,B1,$D$1:$D$10)+MOD(A1,1)+MOD(B1,1)