View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
DUNNER7 DUNNER7 is offline
external usenet poster
 
Posts: 3
Default Calculating difference between dates

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,

"Gary''s Student" wrote:

Excel has a function specifically for this. See:
NETWORKDAYS
in Excel Help.
--
Gary''s Student - gsnu200857


"DUNNER7" wrote:

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