Calculating working days between dates.

D

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
 
A

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
 
Top