thanks for the speedy responce

using 18/01/10 07:44 , returns 22/1/10,
counting 18/1/10 as 1 day, 19th as 2nd day, 20th as 3rd day and 21st and day
4 (so i surpose i should be adding 3 days not 4)
Incidentally, when altering the time to, after 1600hrs, the calculation does
not alter to the next day?

any ideas?


Bob Phillips wrote:
How about this

=WORKDAY(IF(OR(WEEKDAY(A1,2)5,B1TIME(16,0,0)),W ORKDAY(A1,1),A1),3)

HTH

Bob

Hi
I got this formula from one of my old treads, that Bob Phillips sorted for
[quoted text clipped - 22 lines]
Thanks in advance
Brian Thompson

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