Calculate number of days excluding Saturdays and Sundays

[Bryan123]

Hi All,

Would like to ask for your assistance on this if statement.J2 and H2 are 2 different dates. How do I count the difference(remaining days) without including saturdays and sundays?
=IF(AND(M2="NA",I2="No"),0,IF(AND(I2="Yes",J2=0),NOW()-H2,J2-H2))
Thank you
Bryan

 

[steve the fish]

Try this:

=NETWORKDAYS(A1,B1)

This is inclusive so the start and end date is included in the count (provided they are not weekends).