Take a look at =networkdays() in excel's help.

You will have to load the analysis toolpak if you haven't already--but excel's
help will describe how to do that.

(There's another function that you may want to look at, too: =workdays().)

Sheikh Saadi wrote:

I have two columns of Dates. I need a result of Date 2 minus Date 1. This is
pretty simple. this will tell me the number of days. But I need the result to
show me only Business days (i.e., Number of Days in result with no Weekends
--- Saturday and Sunday, excluded).

Please help.

Regards,
Sheikh Saadi

--

Dave Peterson