networkdays - need help

  • Thread starter Thread starter gaspard
  • Start date Start date
G

gaspard

How to calculate a number of days between two dates,
exclude the day's off and knowing that working day's
should be 6 day's per week ?

Thanks a lot
 
Hi:

It depends on which day is the off day (Saturday, Sunday, another day?).
Also, would you want to include holidays?

Regards,

Vasant.
 
Hi Vasant,

The day off is Sunday and yes I need to include some
holidays like 4 july ...
Did you have any idea ?

Regards,
Gaspard
 
Hi,

One way, assuming
Holidays: a range of holidays
A1: Start Date
A2: End Date

=1+A2-A1-INT((A2-WEEKDAY(A2)-A1+8)/7)-SUMPRODUCT((
Holidays>=A1)*(Holidays<=A2)*(WEEKDAY(Holidays)<>1))

Regards,

Daniel M.
 
Hi,

I have found this formula :
=SUMPRODUCT(0+(WEEKDAY(ROW(INDIRECT(E21&":"&H21)),2)=
{1,2,3,4,5,6}))

But need to know where to insert my range of holidays day.

Help is much appreciated.

Thanks
gaspard.
 
Back
Top