Idea to create Employee Shift Schedule in Excel

preview_player
Показать описание
Employee shift schedule template in Excel. Monthly and weekly rotating staff shift schedule or rota.

0:00 Intro
0:58 Week formula
2:22 Conditional Formatting
3:48 Number of employees working
4:08 Change shift
5:08 Month formula

Connect with me on :

#Excel_Series is a comprehensive video series of Microsoft Excel tutorials by The Akshay.
Рекомендации по теме
Комментарии
Автор

2:06 Here in this cell (C4) I have written a formula which I didn't explained in the video because it is optional. If you don't want to change it every month, you can use that formula to check if the cell before it (B4) has the last date of month.

If B4 contains last date of month don't add +1, simply write 1.

TheAkshay
Автор

Great. Now I know more about scheduling shifts and thus I can work more efficiently, effectively, and maximize my income.

ryanfrizzell
Автор

Love the template. Please make it available for download. Thank you

DJrlando
Автор

Could you make this available for a download please 🙏🏿

kimhunter
Автор

Could you please make it downloadable?

lekshmiu