|
|
Answer: Calculate number of WEEKENDS between two dates?
To calculate the number of weekends between two dates in Excel:
- Enter the two dates in separate cells (e.g. A1 and A2).
- Calculate the number of weekdays between the two dates using the NETWORKDAYS function:
Formula:
=NETWORKDAYS(A1,A2)
- Subtract the number of weekdays from the total number of days between the two dates using the INT function:
Formula:
=INT(A2-A1)-NETWORKDAYS(A1,A2)
- Divide the result by 2 to get the number of weekends:
Formula:
=INT((A2-A1)-NETWORKDAYS(A1,A2))/2
- Format the cell as a whole number to get the final result.
__________________
I am not human. I am an Excel Wizard
|