Table of Contents

Weekdays

Use WEEKDAY NETWORKDAYS and WORKDAY to create cool weekday formulas in Excel. Are you ready to improve your Excel skills?

WEEKDAY

The WEEKDAY function in Excel returns a number from 1 (Sunday) to 7 (Saturday) representing the day of the week of a date.

1. The WEEKDAY function below returns 2. 12/22/2025 falls on a Monday.

WEEKDAY function in Excel

2. You can also use the TEXT function to display the day of the week.

TEXT function

3. Or create a custom date format (dddd) to display the day of the week. Cell A1 still contains a date.

Custom Date Format

NETWORKDAYS

The NETWORKDAYS function in Excel returns the number of workdays between two dates. NETWORKDAYS excludes weekends (Saturday and Sunday).

1. The NETWORKDAYS function below returns 11. There are 11 workdays between 12/17/2025 and 12/31/2025.

NETWORKDAYS function

Explanation: the NETWORKDAYS function includes the start date and the end date. The calendar below helps you understand this formula. Simply count the number of circles.

Calendar

2. If you supply a list of holidays the NETWORKDAYS function also excludes holidays.

Workdays

Explanation: simply count the number of circles in the calendar below.

Calendar

WORKDAY

The WORKDAY function in Excel returns the date before or after a specified number of workdays. WORKDAY excludes weekends (Saturday and Sunday).

1. The WORKDAY function below returns the date 1/1/2026.

WORKDAY function

Explanation: the WORKDAY function does not include the start date. The calendar below helps you understand this formula. There are 11 circles.

Calendar

2. If you supply a list of holidays the WORKDAY function also excludes holidays.

11 Workdays Later

Explanation: there are 11 circles in the calendar shown below.

Calendar

NETWORKDAYS.INTL

Use NETWORKDAYS.INTL instead of NETWORKDAYS to specify different weekend days. Use a string of 0’s and 1’s (third argument) to specify which days are weekend days.

1. The NETWORKDAYS.INTL function below returns 8.

NETWORKDAYS.INTL

Explanation: the first 0 tells Excel that Monday is not a weekend day. The second 0 tells Excel that Tuesday is not a weekend day etc. In this example Friday Saturday and Sunday are weekend days. The calendar below helps you understand this formula.

Calendar

Fill Weekdays

To quickly create a list of dates excluding Saturdays and Sundays execute the following steps.

1. For example enter the date 12/17/2025 into cell A1.

Date

2. Select cell A1 and drag the fill handle down. AutoFill automatically fills in the days.

Fill Days

3. Instead of filling in days use the AutoFill options to fill in weekdays (ignoring weekend days).

Fill Weekdays

Note: use WORKDAY.INTL to exclude different weekend days and holidays. Read on.

WORKDAY.INTL

Use WORKDAY.INTL instead of WORKDAY to specify different weekend days. Let’s create a list of dates excluding Mondays Sundays and holidays.

1. Enter the date 12/17/2025 into cell A1 and specify a list of holidays (E1:E2).

WORKDAY.INTL arguments

2. Enter the WORKDAY.INTL function shown below.

WORKDAY.INTL

Explanation: use a string of 0’s and 1’s (third argument) to specify which days are weekend days. The first 1 tells Excel that Monday is a weekend day. The second 0 tells Excel that Tuesday is not a weekend day etc. In this example Monday and Sunday are weekend days.

3. Select cell A2 and drag the fill handle down.

Drag Formula Down

Explanation: the calendar below helps you understand this formula.

Calendar

Conclusion: this formula automatically skips Mondays Sundays and holidays. Pretty cool.

Highlight Weekdays

You can use conditional formatting in Excel to highlight dates that are weekdays (Monday Tuesday Wednesday Thursday or Friday).

1. For example select the range A1:A8.

Select Dates

2. On the Home tab in the Styles group click Conditional Formatting.

Click Conditional Formatting

3. Click New Rule.

Click New Rule

4. Select ‘Use a formula to determine which cells to format’.

5. Enter the formula =AND(WEEKDAY(A1)>1WEEKDAY(A1)<7)

6. Select a formatting style and click OK.

Formula to Highlight Weekdays

Result: Excel highlights all weekdays.

Highlight Weekdays

Explanation: always write the formula for the upper-left cell in the selected range. Excel copies the formula to the other cells. Use the formula =OR(WEEKDAY(A1)=1WEEKDAY(A1)=7) to highlight weekend dates.

Join over 1 million Excel learners by following Excel Easy on Facebook X and LinkedIn.

Leave A Comment

Excel meets AI – Boost your productivity like never before!

At Formulas HQ, we’ve harnessed the brilliance of AI to turbocharge your Spreadsheet mastery. Say goodbye to the days of grappling with complex formulas, VBA code, and scripts. We’re here to make your work smarter, not harder.

Related Articles

The Latest on Formulas HQ Blog