Networkdays.intl vs networkdays

[shukla.ankur281190]

Hi Excel Masters.

Having a problem in a network days formula. Since at my office i am bound to use 2007 so i cant use network.intl formula. in the file u can see column C is the column where network.intl formula is used and i have got my required result i.e count number of days excluding Friday and Saturday

But in column D my formula is wrong bz there i am using network days formula which i have to use at my work place. since the dates i have used in my 2 rows are my only conditions used in my data sheet i need the same answers of Column C in Column D.

Thanks in advance for the reply.

Regards,
Ankur Shukla

[cbatrody]

Hi Ankur,

NETWORKDAYS function by default considers Saturday, Sunday as the weekends. There is no option for you to change the Weekends to Friday, Saturday.

I guess you may have to install some UDF for this to work, go through the following URL for more details.

http://forum.chandoo.org/threads/wor...cel-2007.4773/

[shukla.ankur281190]

Thanks Mr. Cbatrody. I was using the udf but i was thinking that here may be i can get better solution.

So I think there is no other way for this?

[Tony Valko]

Maybe this...

=NETWORKDAYS(A1+1,B1+1)-1

[shukla.ankur281190]

@Mr. Biff,

It wouldn't work

[Tony Valko]

Why not?

It works in your sample file but you only had 2 samples to test it on.