Function Problems

How to Make an Excel Attendance Tracker Count 365 Days

Tauseeq MagsiTauseeq Magsi Nov 2, 2026 868 views

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).

How to Make an Excel Attendance Tracker Count All 365 Days
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 you start

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.

Solution 1Recommended

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.

1
Locate the existing formulas

Open your attendance tracker workbook and navigate to the Calendar View sheet to find the working-days and Last Year formulas.

2
Update the function name

Select the cell with the formula and change 'NETWORKDAYS' to 'NETWORKDAYS.INTL' in the formula bar.

3
Configure the weekend parameter

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.

4
Update the Employee Leave Tracker table

Navigate to the Employee Leave Tracker table and update the first formula in the 'Days' column using the same NETWORKDAYS.INTL modification.

5
Apply the changes

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.

Replace NETWORKDAYS with NETWORKDAYS.INTL
Auto-Fill Confirmation: If the formula does not auto-fill automatically, simply double-click the small green square at the bottom-right corner of the updated cell to drag it down the column.
Seamless Spreadsheet Management

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. 1. Open your tracker: Launch WPS Spreadsheet and open your existing attendance tracker file.
  2. 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. 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.
Fully compatible with Microsoft Excel (.xlsx) formats and complex formulas.Supports advanced date functions including NETWORKDAYS and NETWORKDAYS.INTL.Lightweight, fast-loading, and completely free to use.Offers an extensive library of free, built-in templates for attendance and leave tracking.
microsoft office alternative - wps office

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.