Networkdays counting weekend/holiday

[viperexp87]

Hi I'm currently using NETWORKDAYS formula to find the amount of days lapsed before an invoice is processed after it was submitted to my company. I'm using the formula to account for holidays as well.

I noticed that if the date the invoice is raised falls on a weekend or a holiday, it would effectively count 1 less workday. Is there any workaround for this?

Thank you in advance.

[davsth]

Attach an example with your desired answers as per the yellow banner

[viperexp87]

Attached as requested. Basically I'm trying to calculate the number of days passed excluding the date the invoice was submitted by deducting 1 day off the result. But this would cause an issue if the date the invoice was raised falls on a weekend or holiday as the day itself wasn't already accounted for, resulting in 1 less day from the total.

[davsth]

but if the day was a weekend and a Saturday what should you do? You should really include all eventualities in your example
weekday to weekday
saturday to weekday this does snot exist in the sample
sunday to weekday
holiday to weekday
saturday to weekday but with a holiday in the middle

[viperexp87]

Not sure if you have worked with networkdays before. It basically counts the number of weekdays from date to date, with option to include holiday. Reason I didn't include the examples you stated is because those dates work perfectly fine. The only issue here is that if the start date falls on a weekend or predefined holiday, then it affects my formula to deduct 1 day with the intention to exclude the day it was submitted. Basically I just wanted to deduction of 1 work day to happen only if the start date doesn't fall on a holiday or weekend cause it would double count the deduction.

[davsth]

Yes I have worked with networkdays before and I know what it does
=NETWORKDAYS(A2,B2,G2:G100)-IF(OR(COUNTIF(G:G,A2),WEEKDAY(A2,2)>5),0,1)

might be what you want

[viperexp87]

Thanks for the solution. It worked out as it should.