Calculating difference between dates

[DUNNER7]

I have column c with the start date ex. 9/4/2009 and column d leave date ex.
11/02/09. How can I calculate number of school days (no SAT and SUN) that
the student attended between these two dates in column e?

Thanks
Del Dobbs

 

[Gary''s Student]

Excel has a function specifically for this. See:
NETWORKDAYS
in Excel Help.

 

[DUNNER7]

I saw that function and didn't know how to place/columns in the formula. Do
I select columns c, d, e, and click function and input values? Do I select
column E and format it to take value from columns c and d? I know it must be
something obvious, but I cannot seem to make this work.

Thanks,

 

[David Biddulph]

=NETWORKDAYS(C1,D1)
If you get a #NAME? error, look at Excel help for the NETWORKDAYS function.

 

[edvwvw via OfficeKB.com]

I have column c with the start date ex. 9/4/2009 and column d leave date ex.
11/02/09. How can I calculate number of school days (no SAT and SUN) that
the student attended between these two dates in column e?

Thanks
Del Dobbs

Use NETWORKDAYS ( you will need the analysis addin if using Excel 2003)

Syntax = NETWORKDAYS( Start_date, End_date, Holidays)

edvwvw