Check out the Help on NETWORKDAYS Function.
It is one of the Functions in the Analysis Toolpak add-in.
Gord Dibben Excel MVP
On Mon, 26 Sep 2005 13:56:11 -0700, jsmahnken
wrote:
I have a fairly complicated spreadsheet that utilizes various entered dates
to calculate other dates. The calculated dates must be business days. Is
there a function in Excel 2002 that determines whether or not the calculated
date is a business date?
|