How to Make an Excel Attendance Tracker Count 365 Days
Question details
The user needs to modify an Excel attendance tracker to count every single day of the year (365 days) instead of restricting the count to standard workdays (Monday through Friday).

- Product
- Spreadsheet
- Device & OS
- not provided
- Scenario
- Setting up a continuous 365-day attendance or leave tracker without automatically skipping weekends.
- Observed behavior
- The default tracker template uses the NETWORKDAYS function, which strictly counts only Monday through Friday, resulting in a count that falls short of 365 days for the full year.
Before modifying your formulas, ensure your spreadsheet data is formatted as a structured Table so that changes to one cell will automatically apply to the rest of the column.
Replace NETWORKDAYS with NETWORKDAYS.INTL
Use the NETWORKDAYS.INTL function and configure the weekend parameter to treat no days as weekends, allowing a full 365-day count.
The standard NETWORKDAYS function inherently excludes Saturdays and Sundays. By switching to the NETWORKDAYS.INTL function, you gain the ability to customize which days are considered weekends. To count all 365 days, you can apply a specific string to the weekend argument that tells Excel every day is a working day.
Open your attendance tracker workbook and navigate to the Calendar View sheet to find the working-days and Last Year formulas.
Select the cell with the formula and change 'NETWORKDAYS' to 'NETWORKDAYS.INTL' in the formula bar.
In the NETWORKDAYS.INTL formula, set the third argument (weekend) to "0000000". This 7-character string represents Monday to Sunday, where '0' means a working day, thus excluding no days from the count.
Navigate to the Employee Leave Tracker table and update the first formula in the 'Days' column using the same NETWORKDAYS.INTL modification.
Press Enter. Because the formula is contained within a structured Excel table, the entire Days column should automatically fill with your updated 365-day tracking formula.

Track Attendance for 365 Days Easily in WPS Spreadsheet
WPS Office offers a powerful, free Spreadsheet tool that fully supports advanced date and time functions like NETWORKDAYS.INTL. You can easily build, modify, and manage complex attendance trackers with zero learning curve.
- 1. Open your tracker: Launch WPS Spreadsheet and open your existing attendance tracker file.
- 2. Edit the formula: Click on the cell containing the date formula and change it to use NETWORKDAYS.INTL(start_date, end_date, "0000000").
- 3. Apply across the table: Press Enter. WPS Spreadsheet will instantly calculate the 365-day count and automatically fill the rest of your structured table.

Frequently Asked Questions
What is the exact difference between NETWORKDAYS and NETWORKDAYS.INTL?
NETWORKDAYS automatically and unchangeably excludes Saturdays and Sundays from its day count. NETWORKDAYS.INTL is a more flexible version that allows you to specify exactly which days of the week should be considered weekends or non-working days using a custom numerical parameter or string.
Can I still exclude specific holidays while counting all 365 days?
Yes. The NETWORKDAYS.INTL function includes an optional fourth argument for 'holidays'. You can reference a range of cells containing specific holiday dates, and the formula will subtract those specific dates from your total count.
Why didn't my formula automatically update the rest of the column?
This usually happens if your tracker data is not formatted as an official Table. To fix this, select your entire data range, go to the Insert tab, and click Table. Once converted, editing the top cell's formula will automatically cascade down the column.




