networkdays - need help

[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

 

[Vasant Nanavati]

Hi:

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

Regards,

Vasant.

 

[Gaspard]

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

 

[Daniel.M]

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.

 

[gaspard]

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.

 

[Daniel.M]

You're welcome. Your feedback is appreciated.

Regards,

Daniel M.