Calculate the next business day


I have found help on calculating the number of business days between two dates, but I need to see if there is a way to show the next business day.

I want a field that takes the currentdate and adds 1 day, but if that day is a saturday, sunday, or company holiday, show the next day following that.

currentdate: 6/6/08
@nextworkday: 6/9/08


currentdate: 11/26/08
@nextworkday: 12/1/08 (due to two company holidays)

Any help would be greatly appreciated!
Who is Participating?
mlmccConnect With a Mentor Commented:
Here is a formula that does what you want.

It uses this formula

Éric MoreauSenior .Net ConsultantCommented:
Holidays are not provided by anything because they are related to your contry/state/province. You need to create your mechanism for them.
benbelzerAuthor Commented:
Worked perfectly... thank you.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.