Download the example workbook
This tutorial will demonstrate how to find the number of workdays left in a Month or a Year in Excel and Google Sheets.
The NETWORKDAYS Function calculates the number of workdays between two dates. Its syntax is:
We can use the NETWORKDAYS Function along with other functions to calculate the number of workdays left in a month or year.
Workdays Left in Month
Note: The NETWORKDAYS Function takes ‘Saturday’ and ‘Sunday’ as weekend. You can use the NETWORKDAYS.INTL Function to customise weekend days.
Workdays Left in Month from Today
If you want to find the number of workdays left in the current month starting with today, you can use the TODAY Function as the input date:
Workdays Left in Year
To calculate the number of workdays left in a year, we can use the NETWORKDAYS Function:
Workdays left in Year from Today
To calculate the number of workdays left in the current year starting today, use TODAY as the start date:
How Many Workdays Left in Month / Year in Google Sheets
This formula works exactly the same in Google Sheets as in Excel.