View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default Calculating difference between dates

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

"DUNNER7" wrote in message
...
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