NETWORKDAYS Formula

[Drewmyster]

Hi there,

I need to use the above formula to work out the difference in days between 2 dates.

The only slight variation is that I would need it to work under some conditions;

The sheet effectively has 3 columns of data ranges, and A1 displays the current date =TODAY()

I need the formula to work out if A2 has a date, but B2 does not, to work out the networkdays A2:A1.
But
If A2 has a date AND B2 has a date, to work out the networkdays A,B.
However
If A2 has a date, B2 does not have a date, but C2 does, to work out the networkdays A,C.

I hope this makes sense.

Please advise.

 

[Aladin Akyurek]

Hi there,

I need to use the above formula to work out the difference in days between 2 dates.

The only slight variation is that I would need it to work under some conditions;

The sheet effectively has 3 columns of data ranges, and A1 displays the current date =TODAY()

I need the formula to work out if A2 has a date, but B2 does not, leave blank.
But
If A2 has a date AND B2 has a date, to work out the networkdays A:B.
However
If A2 has a date, B2 does not have a date, but C2 does, to work out the networkdays A:C.

I hope this makes sense.

Please advise.

Something like...

=IF(ISNUMBER(A2),IF(COUNT(B2:C2)=1,NETWORKDAYS(A2,MAX(B2:C2)),""),"")

 

[Jonmo1]

So assuming A2 will always have a date...
And if BOTH B2 and C2 have dates, then use B2..

try
=IF(COUNT(B2:C2),NETWORKDAYS(A2,IF(B2,B2,C2),E1:E20),"")


E1:E20 is your optional range of holiday dates to exclude.

Hope that helps.

 

[Drewmyster]

That's very helpful thanks alot. I managed to use Aladin Akyurek's formula and it worked exactly as I had hoped for.

Many thanks.