BUSDAYNEXT
BUSDAYNEXT(dtDateValue)
Returns the date of the next business day.
| dtDateValue | The unit |
REMARKS
Should this return the next 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 addin BUSDAYPREVIOUS function to return the date of the previous 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
