Sweet, I'm looking at your example rather than your workbook. It seems clear enough: You want to be able to give Excel two dates and have it tell you how many work days are in that range, right? If so, that's what I was talking about in my first response: I think you want the NETWORKDAYS function. I've never used it, but the documentations claims it should do the job.
If that isn't what you want, I think you'll have to try again to explain.
|