Calculating difference between dates

D

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
 
G

Gary''s Student

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

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,
 
D

David Biddulph

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

edvwvw via OfficeKB.com

DUNNER7 said:
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top