BUSDAYPREVIOUS

BUSDAYPREVIOUS(dtDateValue)
Returns the date of the previous business day.

dtDateValueThe unit

REMARKS
Should this return the previous business day if the given date is not a business day ?
* You can use the built-in WORKDAY.INTL function to return the date serial number that is a given number of working days before or after a date.
* You can use the add-in BUSDAYNEXT function to return the date of the next business day.


MORE FUNCTIONS
BUSDAYMONTHSTART* function to return the first business day in a particular month and year.
BUSDAYMONTHEND* function to return the last business day in a particular month and year.
BUSDAYYEARSTART* function to return the first business day in a particular year.
BUSDAYYEAREND* function to return the last business day in a particular year.
BUSDAYNTH* function to return the nth business day in a particular month and year.
BUSDAYSADD* function to return the date after adding or removing a number of business days to or from a date.
BUSDAYDIFF* function to return the number of business days between two dates.


© 2026 Better Solutions Limited. All Rights Reserved. © 2026 Better Solutions Limited TopPrevNext