Networkdays Formula question

[miquele506]

Hello people,

I need this formula to count saturdays and sundays, at this point I don´t really know what to do, any advice?

=IF(OR(Q2={"Cancelled";"Filled";"On Hold"});NETWORKDAYS(R2;U2);NETWORKDAYS(R2;$GD$1))

Any questions please let me know.


Regards,

 

[Jeffrey Mahoney]

You should look at using DAYS360 instead of Networkdays

 

[miquele506]

I´m going to take a look on that and I´ll get back to you if I make it work.

Thanks.

 

[Taul]

Hi
As dates are actually "date serial numbers" you can just subtract them.

try this

=IF(OR(Q2={"Cancelled";"Filled";"On Hold"});(U2-R2);($GD$1-R2))

Paul.

 

[Jeffrey Mahoney]

Dates sometimes contain the time also. Use INT to get the integer value.

 

[miquele506]

Hello guys, in the end I fix this this way:

=IF(OR(R2={"Cancelled";"Filled";"On Hold"});(V2-S2);($GE$1-S2))

It looks simple, but it does the work.

Thanks for all your help.

Consider this post Closed.