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/e...
View my comprehensive courses: https://www.myonlinetraininghub.com/
Connect with me on LinkedIn: / 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
Watch video Excel WORKDAY Function Trick to List Dates that Most People Don't Know online without registration, duration hours minute second in high quality. This video was added by user MyOnlineTrainingHub 05 May 2022, don't forget to share it with your friends and acquaintances, it has been viewed on our site 21,619 once and liked it 644 people.