Mastering Excel - Excel Workday function: Find end date - exclude weekends & holidays | Workday and Workday.intl

5.0 (0)

15 learners

What you'll learn

This course includes

42.5 hours of video
Certificate of completion
Access on mobile and TV

Summary

Keywords

innozant workday function in excel excel workday function excel workday function with holidays excel workday formula workday formula calculate end date workday exclude weekends date based on working days workday exclude holidays workday.intl function in excel workday.intl

Full Transcript

In this video we learn Excel's workday function and do you know this 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. 1. creating a Task and project timeline 2. creating a reporting timetable based the no of days given Kindly note that Workday function assumes weekends fall on Saturdays and Sundays. You will need to use Workday.intl for custom weekend parameter of your choice. Download the Assignment Master Practice Folder here (All Playlist Example at one place) https://drive.google.com/drive/folders/1y5h4SMwPLk12xZ2-2U1SDBIQqyH5bz4P?usp=sharing (Playlist Folder-Basic Excel-Date & Time Folder-workdayfunction1.xlsx) Website - "http://www.innozant.com" Let's Connect: Instagram ►http://www.instagram.com/innozantoffi... Facebook ► https://www.facebook.com/innozant Twitter ► https://twitter.com/innozant Linkedin ► https://www.linkedin.com/company/inno... #vlookupwithifformula#vlookupwithif#Innozant #vlookupfunction

Continue this lesson in the app

Install CourseHive on Android or iOS to keep learning while you move.

Welcome