Not getting exact working days

[nickh1981]

Dear all,

I have a excel file that count the number of working days. I got the formula from the web. But it does not provide me the correct number as i want. Can anyone help on the formula?

[Jean.P28]

there is a formule for you probleme

[salim ali]

use this formula

=NETWORKDAYS.INTL($B$1,$B$2,11,$B$3:$C$3)

[nickh1981]

Hi Jean & Salim,

Thanks for the replied. i am using Excel 2007, NETWORKDAYS.INTL is not supported in 2007. I tried this formula before and i am getting error, that's why i change to SUM formula. Beside NETWORKDAYS.INTL any other formula that i can use?

[quekbc]

One of the holidays (18/1/2015) is a Sunday, thus should be excluded in your SUMPRODUCT. Try this instead.

=SUM(INT((WEEKDAY(B1-{2,3,4,5,6,7})+B2-B1)/7))-SUMPRODUCT(--(WEEKDAY(B3:C3)<>1)*(B3:C3>=B1),--(WEEKDAY(B3:C3)<>1)*(B3:C3<=B2))

[nickh1981]

quekbc,

it works perfectly as i want!!!! Thanks a lot.