Excel Workday function: Find end date - exclude weekends & holidays
Download the workbook here: http://www.xelplus.com/excel-workday-function/
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 ► https://courses.xelplus.com/
✉ Subscribe & get my TOP 10 Excel formulas e-book for free
https://www.xelplus.com/free-ebook/
EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/
Get Office 365: https://microsoft.msafflnk.net/15OEg
Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593
GEAR
Camera: https://amzn.to/2FLiFho
Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161
Microphone: https://amzn.to/2DVKstA
Lights: http://amzn.to/2eJKg1U
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
Видео Excel Workday function: Find end date - exclude weekends & holidays канала Leila Gharani
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 ► https://courses.xelplus.com/
✉ Subscribe & get my TOP 10 Excel formulas e-book for free
https://www.xelplus.com/free-ebook/
EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/
Get Office 365: https://microsoft.msafflnk.net/15OEg
Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593
GEAR
Camera: https://amzn.to/2FLiFho
Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161
Microphone: https://amzn.to/2DVKstA
Lights: http://amzn.to/2eJKg1U
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
Видео Excel Workday function: Find end date - exclude weekends & holidays канала Leila Gharani
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
25 Date and Time Functions in Excel You Need to Know10 Amazing (Less Known) Excel Tricks You Should KnowExcel NETWORKDAYS function: Calculate the number of working days between two datesHow to create Ultimate Excel Gantt Chart for Project ManagementMaster Excel's SUMPRODUCT FormulaHighlight Weekends Dates and Holidays in Excel (Easy Method)Excel: Generating a List of WorkdaysExcel for Accounting - 10 Excel Functions You NEED to KNOW!Searchable Drop Down List in Excel (Very Easy with FILTER Function)Excel Pivot Chart with Slicers for Months to Show Values by Weekday NamesHow Power Query Will Change the Way You Use ExcelExcel Magic Trick 783: Date Functions & Formulas (17 Examples)Excel Pivot Tables EXPLAINED in 10 Minutes (Productivity tips included!)How to Make a Gantt Chart in ExcelHow to Calculate Work Days in Excel (Exclude Holidays & Weekends)Project Plan in Excel with Gantt Chart (Plan, Actual & Progress in ONE VIEW)Excel Sum(ifs) between dates, sum month & sum with multiple criteriaReturn Multiple Match Results in Excel (2 methods)4 SMART Ways to use Custom Formatting instead of Conditional Formatting in Excel - Part 1Excel VLOOKUP: Basics of VLOOKUP and HLOOKUP explained with examples