Calculating working days between dates.

[DKerr]

I am currently creating a spreadsheet with incoming dates in column C
and outgoing dates in column D, in column E I would like to have
formula that would calculate the amount of working days that hav
passed between the two dates, does anyone know if this is possible? an
if so how it could be done?

Thanks

 

[Alex]

You want to use the 'NETWORKDAYS' function in Excel.

So for example

A1

 

[Alex]

You want to use the 'NETWORKDAYS' function in Excel.

So for example

A1

 

[Alex]

Use 'NETWORKDAYS' function.

As an example

A1 B1 C1
01-Sep-04 21-Sep-04 =NETWORKDAYS(A1,B1)
(gives result 15)

You can also account for federal holidays etc. Check out
the Excel help section <F1>

Alex