Excel WORKDAY Function Trick to List Dates that Most People Don't Know
Автор: MyOnlineTrainingHub
Загружено: 2022-05-05
Просмотров: 25347
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
Доступные форматы для скачивания:
Скачать видео mp4
-
Информация по загрузке: