Excel Workday function: Find end date – exclude weekends & holidays



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:
Microsoft Surface:

GEAR
Camera:
Screen recorder:
Microphone:
Lights:

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!

#MsExcel

Tag: workday excel, XelplusVis, Advanced Excel Tricks, Advanced Excel Tutorials, Advanced Excel Online Course, Microsoft Excel Tutorials, Leila Gharani, excel for analysts, Excel reports, Excel report design, Excel 2016, Excel 2013, Excel 2010, Excel workday function, workday formula, calculate end date, workday exclude weekends, exclude holidays, date based on working days, excel workday function not working, exclude weekend in excel date calculations

Xem thêm: https://taichinh4u.net/category/chia-se

Nguồn: https://taichinh4u.net

Hãy bình luận đầu tiên

Để lại một phản hồi

Thư điện tử của bạn sẽ không được hiện thị công khai.


*