formula to Adding to working days

F

Frank Kabel

Hi
try
=WORKDAY(A7,5+(MOD(A7,1)>(10.5/24)))

-----Original Message-----
Ladies and Gentlemen:
Why does this formula not work properly?

=WORKDAY(A7,5+(MOD(A7,6)>(10.5/24)))

A7 cell contains a dd/mm/yy hh:mm format

Basically if the date and time in cell A7 is
before 10:30 then the formula should add 5 working days including that day
if it is after 10:30 then the formula should add 6
Click to expand...
working days including that day
or

it should add 4 working days excluding that day and
if it is after 10:30 then the formula should add 5
Click to expand...
working days excluding that day
 
Top