Calculate number of days excluding Saturdays and Sundays

Bryan123

New Member
Joined
May 23, 2019
Messages
41
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
 

Some videos you may like

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December

steve the fish

Well-known Member
Joined
Oct 20, 2009
Messages
8,080
Office Version
365
Platform
Windows
Try this:

=NETWORKDAYS(A1,B1)

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

Watch MrExcel Video

Forum statistics

Threads
1,102,366
Messages
5,486,437
Members
407,547
Latest member
Sankarasrinivas

This Week's Hot Topics

Top