View Single Post
  #3   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

Look at NETWORKDAYS, you need to have ATP installed but it comes with
excel/office

=NETWORKDAYS(start,end,holidays)

could look like

=NETWORKDAYS(A1,B1,H2:H10)


--

Regards,

Peo Sjoblom

"Carlos" wrote in message
...
I have two columns with date filled in. For example one of
the columns has a date of 02/23/05 the second columns has
a date of 03/01/05. What I need is to calculate the
number of day between the two dates minus the weekend
days. Can anyone help me.