That takes care of the 9 am to 9 pm issue but the workday only stipulation is
still mising. a deadline cannot fall on a weekend.

"LanceB" wrote:

=IF((A1+(8/24))-INT(A1+(8/24))0.875,A1+(8/24)+0.5,A1+(8/24))

"Qaspec" wrote:

I have a date and time in cell a1-a100 i need a formula in b2 that will
provide me with the date and time it will be 8 hours later(deadline). the
deadline only counts for work hours between 9am and 9pm during workdays
mon-fri only. thanks.