How to get the number weekends (saturday and sunday)

[rplim]

How to get the number weekends (saturday and sunday)

4/15/16 and 4/18/16 the answer should be 2.

Can someone share the formula on how to automatically get the weekends? Thank you.

 

[Aladin Akyurek]

=B2-A2+1-NETWORKDAYS(A2,B2)

where A2:B2 houses the input dates with A2 <= B2.

Format the formula cell as General.

 

[rplim]

=B2-A2+1-NETWORKDAYS(A2,B2)

where A2:B2 houses the input dates with A2 <= B2.

Format the formula cell as General.

Thank you for the idea, this one works =(B2-A2)-NETWORKDAYS(A2,B2)+1

Thanks a lot.

 

[Aladin Akyurek]

Thank you for the idea, this one works =(B2-A2)-NETWORKDAYS(A2,B2)+1

Thanks a lot.

Why is that different from the original reposted below?

=B2-A2+1-NETWORKDAYS(A2,B2)