WORKDAY Function Examples in Excel, VBA, & Google Sheets

Written by

Editorial Team

Reviewed by

Steve Rynearson

Last updated on November 6, 2023
Download Example Workbook

Download the example workbook

This tutorial demonstrates how to use the WORKDAY Function in Excel to add business days.
WORKDAY Main Function

Find Nearest Workday

To find the date of the nearest workday use the WORKDAY Function:


Nearest Workday

Find Nearest Workday to Today

To find the nearest workday to today use the TODAY Function with the WORKDAY Function:


Nearest Workday to Today

Find Nearest WORKDAY in 10 Days

This example will find the nearest workday 10 days from the start date:


Nearest WORKDAY in 10 Days

You can also use negative days to look for workdays in the past:

Nearest WORKDAY 10 Before

Workday with Holidays

By default, WORKDAYS will ignore all holidays, however, you can use a 3rd optional argument to define a range of holidays:


Workday with Holidays

WORKDAY in Google Sheets

The WORKDAY Function works exactly the same in Google Sheets as in Excel:

WORKDAY Google Sheet

WORKDAY Examples in VBA

You can also use the WORKDAY function in VBA. Type:


Executing the following VBA statements

Range("E2") = Application.WorksheetFunction.WorkDay(Range("B2"), Range("C2"))
Range("E3") = Application.WorksheetFunction.WorkDay(Range("B3"), Range("C3"))
Range("E4") = Application.WorksheetFunction.WorkDay(Range("B4"), Range("C4"), Range("D4"))

will produce the following results

Vba WORKDAY function
For the function arguments (start_date, etc.), you can either enter them directly into the function, or define variables to use instead.

AI Formula Generator

Try for Free

Excel Practice Worksheet

practice excel worksheet

Practice Excel functions and formulas with our 100% free practice worksheets!

  • Automatically Graded Exercises
  • Learn Excel, Inside Excel!

Free Download

Return to List of Excel Functions