Returns the previous business day if the given date is not a business day.


* 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