Tuesday, 13 March 2018

Workday formula using Excel VBA / How to find next working day in Excel VBA

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

You can use below code if you are using a higher version of Excel.

Function FindWorkDay(InpDate As Date, DaysCount As Long)
FindWorkDay = WorksheetFunction.WorkDay(InpDate, DaysCount)
End Function