Good day,
I want to calculate the number of Saturday & Sunday's between two dates. For example in cell A1 I have 27-Feb-07 and in B1 I have 20-Mar-07 ; is there a formula to calculate the difference the number of Weekend days between those two dates. So in this example it would be 6 days as the answer. The weekends I am refering to are Saturday and Sunday.
Thank you for your help,
I want to calculate the number of Saturday & Sunday's between two dates. For example in cell A1 I have 27-Feb-07 and in B1 I have 20-Mar-07 ; is there a formula to calculate the difference the number of Weekend days between those two dates. So in this example it would be 6 days as the answer. The weekends I am refering to are Saturday and Sunday.
Thank you for your help,