Are you sure, 18/01 07:)) returns 21/01/2010 for me (as you see, I do add 3
not 4)

HTH

Bob


"BNT1 via OfficeKB.com" <u19326@uwe wrote in message
news:a2723e79fd5d7@uwe...
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)), WORKDAY(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