Download the workbook here:
Excel’s workday function is great when you need to calculate an end date based on a given number of working days – which means you need to exclude weekends and holidays. Some examples are
– creating a project timeline
– creating a reporting timetable
In this video I show you both examples.
Excel’s workday function assumes weekends fall on Saturdays and Sundays. In case the weekends in your country fall on other days, you will need to use Workday.intl where you have an additional option to select the weekend days.
★ My Online Excel Courses ►
✉ Subscribe & get my TOP 10 Excel formulas e-book for free
EXCEL RESOURCES I Recommend:
Get Office 365:
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!