Workday Function in Excel: Exclude Weekends and Holidays with SEQUENCE

Learn how to exclude weekends and holidays from lists of dates in Excel (using SEQUENCE + DATE functions). I'll show you how to specify a start date, establish the days argument, and generate a list WITHOUT holidays and weekends.
Check out our other tutorials on using the SEQUENCE formula: • The Best Excel Sequenc...
If you found this video useful or you want to see more like this, give it a like 👍
**JOIN OUR FREE TRAINING SESSION ** excelcampus.com/blueprint #shorts #excel

[@brandon.T1531]

Wow, spill ranges just keep getting better!

[@JessicaJang77]

like👍35 workday function👍 thanks👍

[@Earth-360]

Great!!

[@joannaborromeo3796]

Thank you! Your demo was super quick and straightforward. One of the best--and most helpful--videos I've seen. (This is coming from a beginner.)

[@ExcelCampus]

Thanks Joanna! I really appreciate the nice feedback. 🙂

[@Sir_Gallant]

If you googled "How to Exclude Holidays only" and keep getting videos of the workday function. Then you are actually looking for a tutorial on: MATCH, ISERROR, and IF functions combined to exclude values contained in one range that are duplicates from another range.

[@Sir_Gallant]

How to only exclude Holidays, for example, we will be working on a project for two weeks straight through weekends. No days off. Only Federal Holidays are off.

[@sarahwatson1825]

Thanks for your video. It confirmed I am on the righy track. I am really struggling, though. I need to calculate a date in the furture to INCLUDE weekends, exclude holidays and land on Monday - Friday. I got everything but the landing on Mondy -Friday. Help!

[@harigokul4450]

Great! Can you please tell me how to make the + button for expanding or hiding columns in Excel

[@AndreaUK1973]

Ow Golish!! How did you do THAT?? How come you have “long day” format in your drop down list? Is it because your data is recognised as date formats because of the functions? Does it show if I highlight a data set that is made of only numbers already with dots in between instead of proper date format? Ow I could do with this option in my drop down menu!

[@senorpeppy4699]

great succinct video! may i ask i added the holidays in my formula shown as cells "O2:O9" and it works perfectly. however, then in the next cell when i look at the formula the holiday location moves to "O3:O10". i change that cells formula location to "O2:O9" and it reverts back to "O3:O10" and i get a little green arrow in the upper left cell corner. what is the issue please?

[@nerdypeachmango]

When I click and drag the workday formula to the cells below it, I get a date in the 1900.

[@ExcelCampus]

Hi Peachmango! 😊 Check the formula to ensure that the parts of the DATE function (year, month, day) correspond to the year you are looking for. Hope that helps! 🙂

[@joelchacko8232]

I am assuming Saturdays and sundays are the weekends considered by default in the workday function. Can we change the weekends /workdays.

[@HelloWorld-gt1qp]

I get "#SPILL!" error

[@HelloWorld-gt1qp]

Had to convert table to range for fixing the error. But I wonder how I would be able to do it in a table

[@ExcelCampus]

Interesting thought! One option would be to convert the range back to a table afterwards (Ctrl+T). Another option would be to perform the WORKDAY function spill outside of the table, then copy and paste as values into the table. Any dates that spill past the border of the table will create new rows with blank data except for the date, which avoids the spill error. Hope that helps!