BUSDAYPREVIOUS
Returns the previous business day if the given date is not a business day.
Remarks
* For instructions on how to add a function to a workbook refer to the page under Inserting Functions
* The equivalent JavaScript function is BUSDAYPREVIOUS
Public Function BUSDAYPREVIOUS(ByVal dtDateValue As Date) As Date
BUSDAYPREVIOUS = Application.WorksheetFunction.WorkDay_Intl(dtDateValue, -1)
End Function
© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited TopPrevNext