I'm curious....
How is it that a function whose only purpose is to calculate the number of
workdays
between two dates cannot help you calculate the number of workdays between
two dates?

If the NETWORKDAYS function does, in fact do what you want,
try something like this:
=IF(ISBLANK(G6),"",NETWORKDAYS(E6,G6))

Does that help?
***********
Regards,
Ron

XL2003, XL2007

"housinglad" wrote:

Not really, so what would the function be for 2007 version?

At the moment I have:

=IF(ISBLANK(G6),"",G6-E6)

But that just calculates days not working days.

Thanks
Dan