Target Date & Time Exluding non-business Hours & Weekends (Saturday & Sunday)

Hi Guys,

Please help me. I would like to create a reminder sheet for my employees.

But the below formula which was provided by expert daddylonglegs is counting before the working hours


Cell A2 has TIme and Date :
Example1 : 12/9/2019 09:00 (Monday 9PM)


Cell B2 has 4 (Integer)

Cells E2 and F2 has working hours 10:00 & 19:00 Respectively

Using the below formula in C2 is giving me Result as 12/9/2019 13:00

It should give me 12/9/2019 14:00 because the business hour starts at 10:00 AM. So the target deadline should be counting from the business hour.

Also if A2 date is 12/9/2019 8:00 (Monday 9pm) then the C2 should give me result as 12/10/2019 13:00

HALP !


Formula which I'm applying in C2 : =WORKDAY(A2,CEILING((B2/24+MOD(A2,1)-E$2)/(F$2-E$2),1)-1,D$2:D$9)+MOD(A2,1)+B2/24-CEILING(MOD(A2,1)+B2/24-E$2,F$2-E$2)+F$2-E$2