Sunday, 8 April 2018

How to find next working day in Excel VBA macros

VBA doesn't have an inbuilt function to find the next working day / previous working day.

You can use below code to find the next working day in VBA.

Function GetNextWorkingDay(InptDate As Date)
GetNextWorkingDay = InptDate + IIf(Weekday(InptDate) > 5, 9 - Weekday(InptDate), 1)
End Function

Note : Alternatively You can use the Workday function in Excel if you are using a higher version of Excel as explained in below link. But if you are creating a product which is going to be used in multiple versions of Excel, you should use above code.