Weekdays

 

WEEKDAY | NETWORKDAYS | WORKDAY | NETWORKDAYS.INTL | Fill Weekdays | WORKDAY.INTL

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 weekdays (weekends excluded) between two dates.

1. The NETWORKDAYS function below returns 11. There are 11 weekdays 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 returns the number of workdays (weekends and holidays excluded) between two dates.

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 weekdays (weekends excluded).

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 returns the date before or after a specified number of workdays (weekends and holidays excluded).

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.