Excel WORKDAY Function Trick to List Dates that Most People Don't Know

Most people use the WORKDAY functions to calculate a date in the future skipping weekends and holidays, but not many people know you can give it a custom list of weekdays to skip and return a list of dates.

Download the Excel file and eBook on everything you need to know about date and time in Excel here: https://www.myonlinetraininghub.com/excel-functions/excel-workday-intl-function

View my comprehensive courses: https://www.myonlinetraininghub.com/

Connect with me on LinkedIn: https://www.linkedin.com/in/myndatreacy/

0:00 Introduction
0:32 WORKDAY.INTL example
1:48 Custom weekday parameter
2:35 Return a list of dates with Dynamic Arrays
4:19 Return a list of dates without Dynamic Arrays

Видео Excel WORKDAY Function Trick to List Dates that Most People Don't Know канала MyOnlineTrainingHub