Calculating Time and Dates

[bobgrand]

Hello all,

In the image above Column D "Arrival Date" arrives to this answer using this formula >> =IF(I2="","",WORKDAY(A2,I2,0))

I am struggling incorporating Column G "PO TIME"

The goal is if the PO TIME is after 5:00 pm add 1 more day to the ARRIVAL DATE. The Arrival Date should read Mon-08-26-24.

As always I greatly appreciate any help.

Bob

 

[hagia_sofia]

Hello, would this work for you:

=IF(I2="","",IF(G2>1/24*17,WORKDAY(WORKDAY(A2,I2,0),1,0),WORKDAY(A2,I2,0)))

 

[Accelerate Excel]

Hi Bob,

You can use this formula:
=IF(G3 > TIME(17, 0, 0),WORKDAY(WORKDAY(A3, I3, 0), 1, 0),WORKDAY(A3,I3,0))

Let me know if it works.

Best,
Alain

 

[bobgrand]

Thank you for the help

Both work perfectly.

Have a great day