Calculate next workday when date falls on weekend

I want to 100 calendar days to a date in a cell and when that date falls on a weekend or holiday the formula will return the next workday vs. returning a weekend date.

I tried the workday function but it counted 100 workdays not calendar days.

Thanks in advance


With A1 containing a date...
this formula returns the date 100 days after that date
...if that date falls on a weekend, it incements to the next Monday

B1: =WORKDAY(A1+100-1,1)

Does that help?

Ron Coderre
Microsoft MVP - Excel (2006 - 2010)

P.S. If any post answers your question, please mark it as the Answer (so it won't keep showing as an open item.)

Ron Coderre
Former Microsoft MVP - Excel

41 people were helped by this reply


Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.


Question Info

Last updated October 2, 2020 Views 17,558 Applies to: