To return the next weekday date in Excel, use the WORKDAY function. If A2 contains Friday, January 9, 2026, and F2:F4 contains holiday dates that do not include January 12, enter =WORKDAY(A2,1,$F$2:$F$4); the result is Monday, January 12, 2026.
What “weekday dates” can mean
People use “weekday dates” to mean two different things: dates that fall on working days, or the weekday name attached to a date, such as Monday. Excel handles these as separate tasks. Use WORKDAY to calculate a date while skipping weekend days, and use a date format or a text formula to show a weekday’s name.
By default, WORKDAY treats Saturday and Sunday as weekends. It can also skip a list of holidays. That makes it useful for calculating delivery dates, business deadlines, payment schedules, or a sequence of workdays. It does not automatically know your organization’s holiday calendar, so you must supply those dates if they should be excluded.
Excel stores dates as serial numbers and displays them using a date format. A result may therefore appear as a number if the destination cell is formatted as General. That does not necessarily mean the calculation failed: changing the cell’s format to a date can reveal the calculated calendar date.
Use WORKDAY for the next or previous weekday
WORKDAY has the structure WORKDAY(start_date,days,[holidays]). The start date is the point from which to count, and the number of days tells Excel how many working days to move. A positive number moves forward; a negative number moves backward. The optional holidays argument is a range of dates to skip in addition to weekends.
With the start date in A2 and holiday dates in F2:F4, the formula =WORKDAY(A2,1,$F$2:$F$4) returns January 12, 2026, when A2 is January 9, 2026 and none of the listed holidays falls on January 12. The formula skips Saturday and Sunday. Dollar signs keep the holiday range fixed if you copy the formula elsewhere.
To find a date five working days after the date in A2, with holidays in F2:F4, use =WORKDAY(A2,5,$F$2:$F$4). For a start date of Monday, January 12, 2026, and no holidays during that period, the result is Monday, January 19, 2026. The start date itself is not counted as the first of those five days.
For a prior workday, use a negative day count. With Monday, January 12, 2026, in A2 and no intervening holidays, =WORKDAY(A2,-1) returns Friday, January 9, 2026. The holiday argument can be omitted when there are no additional dates to exclude.
Build a list of weekday dates
A common task is generating a column of consecutive working dates. One approach is to calculate the next workday from the date immediately above it. Enter the first date in A2. In B2, with the starting date in A2 and holidays in F2:F10, enter =WORKDAY(A2,1,$F$2:$F$10). If A2 is January 9, 2026, and January 12 is not a listed holiday, B2 displays January 12.
For a copy-down formula that always counts forward from the original start date, put the start date in A2 and enter this in B2, with holiday dates in F2:F10: =WORKDAY($A$2,ROWS($B$2:B2),$F$2:$F$10). It returns the first workday after A2. Fill the formula down the column using the fill handle or copy and paste. As the formula moves down, ROWS counts 1, then 2, then 3, so the results advance by that many working days from A2. If A2 is January 9, 2026, and no listed holiday intervenes, the first two results are January 12 and January 13.
- Enter a real Excel date as the starting point.
- Put any dates to exclude in a separate range, one date per cell.
- Enter a WORKDAY formula in the first result cell, using an absolute reference for the holiday range.
- Copy the formula down as far as you need, then format the output cells as dates.
This produces a list with no weekend gaps. If you need every calendar date, including Saturday and Sunday, use ordinary date addition instead; WORKDAY intentionally skips its defined weekend days.
Exclude holidays correctly
The optional holiday range lets WORKDAY skip public holidays, company closures, or other nonworking dates. Put each holiday in its own cell and make sure Excel recognizes each entry as a date value, not text that merely looks like a date. A useful check is to change a holiday cell’s number format: a genuine date will display as a date or as a serial number when formatted as General.
With January 12, 2026, in A2 and the holiday date January 13, 2026, in F2, the formula =WORKDAY(A2,1,$F$2:$F$2) returns January 14, 2026. January 12 is the start date; the next working day, January 13, is skipped because it is in the holiday range, so the result moves to January 14.
Keep holiday dates in a maintained list rather than typing them into every formula. That makes annual updates easier and reduces the chance that one calculation uses a different calendar from another. If the list grows, expand the referenced range or convert the holiday list into an Excel table and use an appropriate table reference. Check for duplicate dates if you are reviewing the list, although duplicates do not make the same date get skipped twice.
Use a different weekend pattern
If your workweek is not Monday through Friday, use WORKDAY.INTL. Its structure is WORKDAY.INTL(start_date,days,[weekend],[holidays]). The weekend argument can identify a preset weekend pattern or use a seven-character string in which each position represents Monday through Sunday: 1 means a nonworking day and 0 means a working day.
For example, if Friday and Saturday are weekends, enter 7 as the weekend code. With Friday, January 9, 2026, in A2, no holidays, and a Friday-Saturday weekend, =WORKDAY.INTL(A2,1,7) returns Sunday, January 11, 2026. Sunday is the next working day under that pattern. The preset code 1 represents the standard Saturday-Sunday weekend.
A custom pattern can represent less common schedules. With Monday in A2 and a seven-character weekend string of 0000011, Saturday and Sunday are marked nonworking while Monday through Friday are working. For a rotating schedule or dates that depend on a particular employee’s shifts, a single fixed weekend pattern may not be enough; a calendar table with explicit working and nonworking dates can be clearer.
Show the weekday name or check a date
If you already have a date and only want to display its weekday, you do not need WORKDAY. With a date in A2, select the cell and choose a date format that displays the day name. On Windows, press Ctrl+1 to open Format Cells, choose Custom, and enter dddd for the full weekday name or ddd for an abbreviation. On Mac, Command+1 opens Format Cells. The value remains a date, so it can still be used in date calculations.
To create a separate text label instead, with a date in A2, use =TEXT(A2,"dddd"). If A2 is January 12, 2026, it returns Monday. TEXT returns text rather than a date value, so use the original date cell for sorting or calculations. The displayed language may depend on Excel’s regional settings.
You can also test which weekday a date falls on with WEEKDAY. With January 12, 2026, in A2, =WEEKDAY(A2,2) returns 1. Using 2 as the second argument numbers Monday as 1 through Sunday as 7, which is convenient for checking a Monday-to-Friday workweek. This formula identifies the day; it does not move a date forward or skip holidays.
Common problems and how to fix them
- The result looks like a number: Format the result cell as a date. Excel stores dates as serial values, and a number format controls how those values appear.
- A weekend date appears in the result: Check whether you used WORKDAY.INTL with a weekend pattern that treats that day as a working day. The standard WORKDAY function skips Saturday and Sunday.
- A holiday is not skipped: Confirm the holiday is a real date value and falls inside the range referenced by the formula. Check that the formula’s range includes the correct year and cells.
- The result is one day later or earlier than expected: Remember that WORKDAY does not count the start date as day one when moving by a nonzero number of workdays. Also check whether the start date itself is a weekend or holiday.
- The weekday name appears in the wrong language: A custom date format or TEXT output can follow regional language settings. The underlying date calculation is separate from the name Excel displays.
When a formula returns an error, check that the start date is valid and that the day count is numeric. Also verify that separators match your Excel settings. The examples here use commas, as in standard Microsoft 365 for Windows setups; some regional configurations use semicolons in formulas.
Frequently Asked Questions
How do I get the next weekday in Excel?
Use WORKDAY with the date cell as the start date and 1 as the number of days. Add a holiday range if dates such as public holidays should also be skipped.
Does WORKDAY count the starting date?
No, not when you move by a nonzero number of workdays. A count of 1 means the next workday after the start date, not the start date itself.
Can Excel return weekdays while including Saturdays?
Yes. Use WORKDAY.INTL and choose a weekend pattern that marks only the days your schedule treats as nonworking. For example, its preset weekend code 11 marks Sunday as the sole weekend day.
How do I return Monday, Tuesday, or another weekday name?
Apply a date format such as dddd to the date cell, or use TEXT to create a text label. Formatting preserves the date value; TEXT produces text.
How can I make a list of weekday dates?
Calculate the first workday after a starting date, then copy a formula down that advances by one workday each row. Include a holiday range if the list must follow a specific calendar.
Why does my formula return a number instead of a date?
Excel stores dates as numbers. Change the result cell’s number format to a date format; the displayed value should then appear as a calendar date.
Related
- Real Estate Excel Template for Cash Flow: Build One
- Real Estate Excel Budget Template: Setup and Costs
- Randomize Numbers in Excel Without Duplicates
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- Excel Filter Including Wrong Data? Find the CauseIf an Excel filter includes the wrong data, first check that the filter covers the correct range and…
- Excel Filter Just for Me: Create a Personal Sheet ViewTo filter a shared Excel worksheet just for yourself, create a Sheet View first, then apply the filter…
- Excel Let Text Spill Into the Next Cell? How It WorksYes. In Excel for Microsoft 365, text can appear to spill into the cell to its right when…
- Excel Multiply If Not Zero: Formula & GuideTo multiply only when a cell is not zero in Excel, use the IF function: =IF(A2=0,0,A2*B2) or, if…
- Excel TRIM Formula Examples for Cleaning Messy TextIn Excel for Microsoft 365, use =TRIM(A2) to remove leading and trailing ordinary spaces from the text in…
- Excel Sentence Case Formula: One Sentence or Many?For a cell in A2, use =UPPER(LEFT(A2,1))&LOWER(MID(A2,2,LEN(A2))) to capitalize the first character and make the rest lowercase. This…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.