VBA I want to calculate the difference between two days excluding the weekends

Hi,

I have this problem for 2 days now, I keep on trying to calculate the two dates that will give me the total fines, The Total fines can be calculated by the number of days that the book has been burrowed excluding weekends(Saturday and Sunday) which means "Date Today - Date Due" but I need to calculate the fines without counting the weekends. For example The Due Date was on Oct 04, 2019 and The book was returned on Oct 07, 2019 the total fines should only be "1" not "3".

I just dont know what code to use.

Please see Image, Code Thanks. Below Thanks.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Capture.PNG

Hi WideBoyDixon,
Wow, It worked. Thanks a lot. I owe you one.

Hi, I am having a problem with the code right now.
The value in FinesTxtbox.Value Keep on returning 21, how do i solve this?
Attachment 644536

Please Login or Register  to view this content.

Originally Posted by WideBoyDixon

There is no attachment. However, I'd also need to know what values you were putting into the two date fields and why 21 is incorrect.

WBD

Okay in my office computer the sum of the value is 21 the dates that I am subtracting are 10/08/2019 and 10/09/2019 the value is always 21 but in my laptop the value is correct. Is there something wrong with my office computer or is it just that my laptop is better.