Function Problems

How to Create a 2025 Workday Calendar Column in Excel

Maira Mehtab Sep 22, 2026 869 views

Question details

The user needs to generate a vertical column listing all workdays for the year 2025, formatted to show the weekday, month, date, and year, with the option to exclude public holidays.

Product: Microsoft Excel
Device & OS: not provided
Scenario: Creating a structured yearly work schedule, attendance tracker, or project calendar that only includes working days.
Observed behavior: A populated column of consecutive working days excluding weekends and optionally holidays, displayed in a specific date format.

Before you start

Gather a list of your specific public or company holidays for 2025 to ensure they can be accurately excluded from your workday calculation.

Solution 1Recommended

Use the WORKDAY.INTL Function to Generate a Workday List

This method uses Excel's built-in WORKDAY.INTL formula to automatically calculate the next working day, easily skipping weekends and specified holidays.

The WORKDAY.INTL function is highly flexible, allowing you to define which days of the week are considered weekends and seamlessly pass a range of holiday dates to skip.

Enter the starting date

In a starting cell, such as A2, type your first workday of the year (e.g., '2-Jan-2025' or '1-Jan-2025').

Apply the WORKDAY.INTL formula

In the cell directly below it (A3), type the formula =WORKDAY.INTL(A2,1) to calculate the next standard workday.

Exclude public holidays (Optional)

Type your 2025 holiday dates in a separate column. Highlight them, name the range 'Holidays' in the Name Box, and update your formula in A3 to =WORKDAY.INTL(A2,1,,Holidays).

Fill the formula down

Select cell A3, click and hold the small square at the bottom-right corner (fill handle), and drag it down the column to populate the rest of the workdays for the year.

Apply custom date formatting

Select your entire column of generated dates, right-click, and choose 'Format Cells'. Go to the 'Custom' category and enter 'dddd, mmmm d, yyyy' into the Type box, then click OK.

Formatting Tip: Using the custom format 'dddd, mmmm d, yyyy' ensures your dates display exactly as 'Thursday, January 2, 2025', making your calendar much easier to read.

Smart Spreadsheet Management

Create Your 2025 Workday Calendar Easily in WPS Spreadsheet

WPS Office offers full support for advanced date functions like WORKDAY.INTL, allowing you to quickly generate custom calendars, project schedules, and employee rosters with full Microsoft Excel compatibility.

1. Open a New Spreadsheet: Launch WPS Spreadsheet and create a blank workbook.
2. Input the Start Date: Type '1-Jan-2025' or '2-Jan-2025' in cell A2.
3. Apply the Formula: In A3, enter =WORKDAY.INTL(A2,1) and drag the fill handle down to generate the 2025 workdays.
4. Format the Dates: Select the populated dates, press Ctrl+1 to open Format Cells, go to Custom, and enter 'dddd, mmmm d, yyyy'.

Fully compatible with Microsoft Excel date formulas including WORKDAY and WORKDAY.INTL.Free to use with a lightweight installation and fast, reliable performance.Intuitive UI for creating named ranges and applying custom date formats effortlessly.

microsoft office alternative - wps office

Frequently Asked Questions

How do I exclude weekends other than Saturday and Sunday?

In the WORKDAY.INTL function, you can use the third argument to specify custom weekend parameters. For example, =WORKDAY.INTL(A2, 1, 11) sets Sunday as the only weekend day. Check the function's tooltip in Excel for the full list of weekend numeric codes.

Why am I getting a #VALUE! error when entering the date?

This usually happens if the software does not recognize your initial date entry as a valid date format. Ensure you enter the start date in a format that your system's regional settings recognize, such as MM/DD/YYYY or DD-MMM-YYYY.

Can I use the WORKDAY function instead of WORKDAY.INTL?

Yes, if your weekends are strictly Saturday and Sunday. The standard =WORKDAY(start_date, days, [holidays]) function operates identically but lacks the option to customize which specific days of the week are treated as weekends.

Excel & Data Problems