How to create a work schedule in Excel, How to schedule employees for shift work. How to ensure you have enough employees to each shift. To receive a copy of this file email me at easyexcelanswers@gmail.com to request it.
Check out my online courses
Become an Affiliate and earn 25% on Course Sales
For more help visit my website or email me at easyexcelanswers@gmail.com.
Contact me regarding customizing this template for your needs.
Excel one-on-one on-line training available. Email me to arrange.
I am able to provide online help on your computer at a reasonable rate.
Check out my next one-hour Excel Webinar
I use a Blue condensor Microphone to record my videos, here is the link
Check out Crowdcast for creating your webinars
If you need to buy Office 2019 follow
I use Tube Buddy to help promote my videos
Check them out
Follow me on Facebook
TWEET THIS VIDEO
Follow me on twitter
easyexcelanswers
IG @barbhendersonconsulting
You can help and generate a translation to you own language
*this description may contain affiliate links. When you click them, I may receive a small commission at no extra cost to you. I only recommend products and services that I’ve used or have experience with.
Watch more new videos about Excel Office | Synthesized by Mindovermetal English
Really well done Barb!! Thank you so much. I learned more about Excel than I ever have and was able to create a shift scheduling template that works for me. I appreciate it!!
I’m confused on how you got Aug 1st in the beginning to start the dates. Could you elaborate on this?
Thank you so much. This made me a rockstar at work.
Help! I got lost in minute 3:22. How do I get to the countiff option? Is it a double click?
how can I make the "number needed" move with the days. I.e. I need more personal during the weekend than the weekdays?
Hi Barb, thanks for uploading your video its a huge help with me sorting our roster…thanks a mil.
Thank you Barb, for the insightfull sharing on how to create real active calender work schedule.
Mam , I need to keep the data of every dates and have to visit other days ..
In your tutorial , When the dates change the input data doesn't changes
Can anyone tell me how to add a column that's shows the letter for the day, such as M T W T F S
Or you could just use a Microsoft Excel Template and just enter Excel codes when needed.
Thanks for this, very helpful
Hi Barb thanks so much can you email me the template for the work schedule I have 3 shifts 7am-3:30 pm 3pm-11:30pm 11:30pm -7am I tried to do it but I got lost along the way thanks!
Is there a way to gray out the weekends on the schedule below? Using a formula?
Thanks a lot for sharing this video .
Great information, Thank you Barb
how do I black out the cells?
Great..
Many thanks, just every time I enter days formula on beginning of schedule doesn't work(on the start schedule row),starting from day 1 , even I've searched for day formula (dayformula) it gives me this ( ###)…any help!!
Thanks for the video. Now I understand how to use =weekday function
Amazing boss
Maybe slow down and actually show what you are clicking on. Way too fast, I could not keep up.
Can I pls ask u how can I create a daily deployment for the whole month which gets the data of the shift workers from the front sheet
How to create excel sheet for substitution of employees in a and b shift ?
If anyone is on leave than it should be automatically be replaced by other in that shift ?
Thanks ma'am really appreciate it
You are doing a fantastic job. Thank you so much for sharing your valuable knowledge 🙂
Looking forward to creating one for a project.
Amazing! Thank you. (:
if I want to at a value of time to the "X" of 8 hours or they start at 7am and a 10 hour shift? and if they start at 7 am, can that persons name be added to a list of names that are starting working at 7am. in a another column?
Can u show me how to do a 10 days shift system whereas i work 10 days and i get 7 days off. Thank u please
hi great vid! can u help me make a 12hour schedule for a whole month with 5 employees? we work 22days a month 8hours a day , and it will shorten our workdays to 15days if we can make a proposal for 12hour schedule sheet. really hoping for a positive feedback. thanks!
Thank you very much for sharing.
I've really learnt a great deal