NETWORKDAYS formula

[Silverscreen]

I have been trying to get NETWORKDAYS formula to work but for some reason it just won't do it. I have resorted to using the below formula but it just doesn't seem to want to take into account the holidays.

so the formula is: IF(WEEKDAY(A3,2)>5,"",NETWORKDAYS(A$2,A3,$R$3:$R$10))

A3 is the actual date, A2 is the first date, R3 to R10 are the holidays. you can see from the results below (06 May is supposed to be a bank holiday, included in R3:R10) but it is still bringing back a result.

DATE	DAY	WD
01-May	Wednesday	1
02-May	Thursday	2
03-May	Friday	3
04-May	Saturday
05-May	Sunday
06-May	Monday	3

<colgroup><col width="90" style="width: 68pt; mso-width-source: userset; mso-width-alt: 3291;" span="2"> <col width="75" style="width: 56pt; mso-width-source: userset; mso-width-alt: 2742;"> <tbody> </tbody>

When I use just NETWORKDAYS(A$2,A2), it brings back numbers for weekends:

DATE	DAY	WD
01-May	Wednesday	1
02-May	Thursday	2
03-May	Friday	3
04-May	Saturday	3
05-May	Sunday	3
06-May	Monday	3

<colgroup><col width="90" style="width: 68pt; mso-width-source: userset; mso-width-alt: 3291;" span="2"> <col width="75" style="width: 56pt; mso-width-source: userset; mso-width-alt: 2742;"> <tbody> </tbody>

 

[Gerald Higgins]

What do you want the results to be, and why ?
If 6th May IS a holiday, then the results look OK to me.
Am I missing something ?

 

[Tetra201]

Is this what you need?

=IF(A3=WORKDAY(A3-1,1,$R$3:$R$10),NETWORKDAYS(A$2,A3,$R$3:$R$10),"")

 

[Silverscreen]

Is this what you need?

=IF(A3=WORKDAY(A3-1,1,$R$3:$R$10),NETWORKDAYS(A$2,A3,$R$3:$R$10),"")

Thank you! just what I need