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
Смотрите видео Excel WORKDAY Function Trick to List Dates that Most People Don't Know онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь MyOnlineTrainingHub 05 Май 2022, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 21,619 раз и оно понравилось 644 людям.