Return next working day

This tutorial shows how to return the next work day (business day) using an Excel formula or VBA

Example: Return next working day

Return next working day

METHOD 1. Return next working day using Excel formula

EXCEL

=WORKDAY(B5,1,$F$5:$F$12)
This formula uses the Excel WORKDAY function, including the holidays, to calculate the next working day from the selected date.

METHOD 1. Return next working day using VBA

VBA

Sub Next_working_day()
'declare a variable
Dim ws As Worksheet
Set ws = Worksheets("Analysis")
'return the next working day
ws.Range("C5") = Application.WorksheetFunction.WorkDay(ws.Range("B5"), 1, ws.Range("F5:F12"))

End Sub

Explanation about how to return next working day

EXPLANATION

EXPLANATION

This tutorial shows how to return the next work day (business day) through the use of an Excel formula or VBA.
Both the Excel formula and VBA methods make use of the WORKDAY function to return the next working day.
FORMULA
=WORKDAY(date,1,holidays)
ARGUMENTS
date: The initial date from which to begin counting the number of working days.
holidays: A list of dates that specifies the holidays to take into consideration.

RELATED TOPICS

Related Topic Description Related Topic and Description
How to return the current date using Excel and VBA