differnet between two date

[thair]

Hi
I have formula for find the different between two date
and i should put a list to (Daysoff) , and I don't know where exactly
should i put this list . I attached file with formula
Thank you

Please Login or Register  to view this content.

Notice : I put red color to part of formula (Daysoff)

[daddylonglegs]

The idea is that Daysoff is a range containing any holiday dates, you can list those anywhere you want, for example if you have holidays listed in H2:H10 you can use this formula

=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A2&":"&B2)))<>6),--(ISERROR(MATCH(ROW(INDIRECT(A2&":"&B2)),H$2:H$10,0))))

....but if you have excel 2010 you can get the same result with NETWORKDAYS.INTL function, i.e.

=NETWORKDAYS.INTL(A2,B2,17,H$2:H$10)

[thair]

Hi daddylonglegs
I try it but not working
and I use Excel 2010
I tried two formula , and not working
can you help me please , because i need it
Thank you

[daddylonglegs]

See attached

[thair]

See attached

Hi daddylonglegs
can you explain to me please what mean this part in your formula
in a red color.

Please Login or Register  to view this content.

Ans i want you know , we have to days off at a week Friday and Saturday

[daddylonglegs]

The formula you quoted is consistent with having only Friday as the weekend, I made a mistake - 17 is the code for Saturday weekend, I should have used 16 for Friday...

....but you say you want to exclude Friday and Saturday so that would be one of these:

=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A2&":"&B2)))< 6),--(ISERROR(MATCH(ROW(INDIRECT(A2&":"&B2)),H$2:H$10,0)))

or

=NETWORKDAYS.INTL(A2,B2,7,H$2:H$10)

[7 is the code for Friday and Saturday weekends]

or

=NETWORKDAYS(A2+1,B2+1,INDEX(H$2:H$10+1,0))

all should return the same results

[thair]

Thank you very much daddylonglegs
Multiplicity for solution is very good thing
And your replied was very useful to me
thanks a lot