Excel - Employee Calendar Using WORKDAY function - Episode 2024

2,523 views · Published 19 September 2016 · 4:15 · Indexed 8 November 2026

Channel: MrExcel.com · 2016 · Education

Watch on YouTube

Microsoft Excel Tutorial - Creating an Employee Calendar Using the WORKDAY function.

Welcome to episode 2024 of the MrExcel podcast, where we will be diving into the world of Excel and learning how to create a workplace calendar using the WORKDAY function. If you're new here, make sure to subscribe to the playlist by clicking the "i" on the top-right hand corner of your screen.

In our previous episode, we discussed the NETWORKDAYS.INTL function and how it can be used to calculate the number of workdays between a start date and an end date. Today, we will be exploring its complementary function, WORKDAY, which can be used to calculate an ending date based on a given number of workdays.

Let's take a look at an example where an employee is on probation for 30 workdays starting from a specific date. By using the WORKDAY function, we can easily calculate the end date, taking into account any holidays that may occur during that time period. However, this function can also be used for more practical purposes, such as creating an employee schedule or calendar.

For instance, let's say we have a marketplace that is open on Mondays, Thursdays, Fridays, and Saturdays. Using the WORKDAY function, we can easily calculate the next day the marketplace will be open, based on the current day. This can be done by simply inputting the start date, the number of days to go out, and the weekend parameters (either as a binary string or a value). We can also include a list of holidays to be excluded from the calculation.

But that's not all, the WORKDAY function can also be used for businesses that operate on a different schedule, such as a manufacturing plant that is open 6 days a week and closed on Sundays. By inputting the start date, the number of days to go out, and the weekend parameters, we can easily create an employee schedule that takes into account any holidays that may occur.

This tip is just one of the many bonus tips included in my book, "Excel 40 Greatest Tips". So make sure to click the "i" on the top-right hand corner to purchase the book and learn even more useful Excel tips and tricks. And don't forget to check out our previous episode, where we introduced the NETWORKDAYS and NETWORKDAYS.INTL functions.

Thank you for tuning in to this episode of the MrExcel podcast. We hope you found this tutorial on the WORKDAY function helpful and stay tuned for more Excel tips and tricks in our future episodes. See you next time!

Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/

You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/


Table of Contents:
(00:00) Employee Calendar in Excel using WORKDAY function
(00:14) Using NETWORKDAYS.INTL to calculate workdays
(00:39) Using WORKDAY to calculate end dates
(01:16) Example of using WORKDAY for a business schedule
(01:56) Adjusting the formula for different scenarios
(02:36) Using WORKDAY.INTL for a manufacturing plant schedule
(03:40) Recap
(03:52) Clicking Like really helps the algorithm

#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial #excelformula #excelformulasandfunctions #exceldates

This video answers these common search terms:
how to make a calendar for employees in excel
best way to create a calendar on excel
can you do a calendar on excel
creating a calendar in excel
making a work week calendar in excel
how to create work calendar in excel
how to make a work calendar in excel
how to build a work calendar using excel
how to add a calendar worksheet to excel
how to make a calendar for excel for work
does workday formula in excel exclude holidays
how do you use the workday function in excel
how to create workday formula in excel
how to enter the workday formula in excel
how to excel workday
how to use the workday function in an excel formula
calculate next workday

Yesterday in podcast 2023 I used NETWORKDAYS and NETWORKDAYS.INTL
There is a similar pair of functions WORKDAY and WORKDAY.INTL
This function takes a start date, then a number of days, weekend type and holidays and calculates the end date.
For example, calculate when a 30 work-day probation period might end.
But a more common use might be to build an employee schedule or employee calendar
Put the first start date. Then add 1 workday using WORKDAY or WORKDAY.INTL.
Drag that formula down to build the schedule.

Join the MrExcel Message Board discussion about this video at  https://www.mrexcel.com/board/threads/1153851/

More from this channel