Excel Workday function: Find end date - exclude weekends & holidays | Workday and Workday.intl
HTML-код
- Опубликовано: 15 окт 2024
- 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)
drive.google.c...
(Playlist Folder-Basic Excel-Date & Time Folder-workdayfunction1.xlsx)
Website - "www.innozant.com"
Let's Connect:
Instagram ► / innozantoffi. .
Facebook ► / innozant
Twitter ► / innozant
Linkedin ► / inno. .
#vlookupwithifformula#vlookupwithif#Innozant #vlookupfunction