Quote Originally Posted by humdingaling View Post
based on that criteria
i made some amendments to the formula
439 shows as 3 now

used column F again just so the formula looks neater to troubleshoot
if the final formula you can incorprate the weekend() bit into the if formula
Great, thanks again for the help
D