How to Generate a List of Business Days in Excel - Office 365

preview_player
Показать описание
When creating dashboards and reports in Excel, it's often useful to have a helper table that contains a list of dates that represent business days or work days (dates that are not weekends or holidays). You can use the WORKDAY function to generate the list of business or work days. If you want to have other than Saturday and Sunday as weekend days then you can use WORKDAY.INTL function to generate the list of business days or work days.

To download the example Excel file used in this video please click on the link below
Рекомендации по теме
Комментарии
Автор

Pretty useful, thank you for creating this video🙂

olaodup
Автор

Great video btw I am facing with an issue regarding sheet1 - Im doing the same way but Monday is being created triple, why?

masaudamin