WORKDAY exclude holidays next Workday date

SOLTEC

SOLTEC

Board Regular
Joined
Feb 11, 2015
Messages
195
Office Version
  1. 365
  2. 2019
Platform
  1. Windows
What is a formula for WORKDAY to exclude holidays, but get the next Workday for the cell, please. Any and all assistance is greatly appreciated.
 

Excel Facts

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes
Sort by date Sort by votes
Take a look at the WORKDAY.INTL function
 
Upvote 0
Is that also a built-in function in Excel?
 
Upvote 0
Will that function give me the next workday? If so, what is the syntax, please
 
Upvote 0
You have to refer to a range of dates in the 4th parameter of the function. It is pretty obvious. Take a look at the microsoft page for that function to see examples
 
Upvote 0
=WORKDAY.INTL(DATE(2012,1,1),90,12) would be the following Monday? If the date was a weekend or holiday?
 
Upvote 0
Try
Excel Formula: 
=WORKDAY(DATE(2012,1,1),1,H2:H10)
where H2:H10 hold the list of holidays.
 
Upvote 0
You must log in or register to reply here.

Similar threads

E
  • Solved
How to Use IF Statement with WORKDAY function
Replies
5
Views
299
Fluff
Fluff
E
  • Solved
How to use WORKDAY to calculate the Final Training Day and exclude Weekends and Public Holidays
Replies
5
Views
283
Fluff
Fluff
M
  • Solved
Formula to Return Next Monday in WORKDAY
Replies
4
Views
367
Fluff
Fluff
E
  • Solved
Unexpected flaw in WORKDAY formula to calculate date
Replies
7
Views
372
KRice
K
C
  • Question
Formula Result Change to next Workday
Replies
3
Views
323
Fluff
Fluff

Forum statistics

Threads
1,215,338
Messages
6,124,346
Members
449,155
Latest member
ravioli44

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top