Brian,

I think it would help if you give examples of all the possibilities and
expected results, let's get it finished <vbg

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"brian thompson3001 via OfficeKB.com" <u15682@uwe wrote in message
news:5cf41483ca8b6@uwe...
Hi bob

nearly there !

The weekend's do seem to be givinng problems. Any weekend date and friday
after 1600, to reflect mondays date

regards
Bob Phillips wrote:
=WORKDAY(A1,IF(OR(WEEKDAY(,2)5,B1TIME(16,0,0)), 5,4))

understand, but if date of 4/3/06 and time 02:01:01 , then it returns a
date
of 09/03/06 and require 10/3/6
[quoted text clipped - 8 lines]

brian

--
Message posted via http://www.officekb.com