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

Описание к видео 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

Комментарии

Информация по комментариям в разработке

Похожие видео