what I've created you is a shift schedule that you can enter a shift by
start date now you probably don't have that much of a turnover and hopefully
you don't have that make sure a turnover of all your staff but if you did you
would enter their start date and so let's say we had somebody that was
starting on January 7th and we'll say his name is employee 12 so what I'm
gonna do is I can click the button into shifts and I'm gonna go employee 12 and
then it's gonna search for that and then you're gonna say he started on the
seventh okay and so then I'm gonna go enter date and until I go clear form and
then close it and I'm gonna go control home to get back to my beginning
five days two days off five evenings two days off five nights now at the bottom
of your sheet you can see I've got two shifts in here already and you can see
that you have two days zero evenings zero nights here and so you can keep
track of if you've got you all the shifts covered now this this will repeat
for the entire year and what I've done is I've added on extra extra days so
that if it would goes over the end of the year it will be be able to hit see
what shifts are going forward so what I've done is I select each range in a
drop-down list here from I've named the ranges and so let's do name December so
here we go this is the December 2:19
and then considering it's probably going to go over if you had someone starting
in November it would be going over and so I've included into January February
and a little bit of March just so that you can see where it's going over with
your shifts now I will include the code and here you still have the totals of
the days the nights and the evenings I will include this coding the description
of my thing and what I've done here is I've just dragged I've dragged
the January first - J - all the way across to the end of the time that I
want and how I put there days of the week up here is I've used vlookup let me
go to sheet number two I've created a table and vlookup so what we've done
here in here is we've said week day we looked up the V we've looked up the
weekday of this cell here and the weekdays are in Microsoft number one is
Sunday and number seven is Saturday and so using the vlookup we've included the
name of the day of the day of the week on top of the date here so that you're
able to see what you're doing with with the shifts and then of course we have
I've done this by using count if so count if the range of cells here and if
it equals D then it's a it's number of days and the same thing for evenings and
nights right and so once again let me show you the code and so what I've done
is I have for the lookup box I've used a combo box and then I've looked if it's
January February or March all the way down and then it's put its counted the
days within that and then so what I've done is if on the right when you've
figured the active cell and that's just the cell that you've selected choosing
the up the month and the day and so that's the active cell and then I've
just added then it starts with the first the first day for a first active cell
will be days and then it's been added four additional days two additional days
off then it's added seven or sorry five additional evenings to two days off five
nights and two days off now when I divided 20 into because this is a shift
of 20 basically into 365 I came up with about 18 and so I did 19 make sure we
covered the whole thing and so I'm right I'm repeating this 19 times in a year
so this is how you create as a shift from the start of the start day
and and how it goes now when you have your shifts already in here and you know
you're looking at this and you're playing around to shift so that you can
get the it covered and you're thinking who this guys shouldn't be working this
and so all you do to delete this shift is you click on the cell that you want
to start with you press ctrl shift and and the right-facing error and it goes
to the end of the days and then maybe you might want to instead of starting on
on the 10th here maybe you want to start him on the 5th so then it's just just
just a matter of entering your employees go employee to and then we're going to
store him on the 5th
now clear the form we'll go control home to get back to where we were and they're
there you have your your in there and that might make change of totals on you
now the other thing too is that you can
start so you probably all have an employee starting at noon all of
November or let's say the middle of October of next year so what you can do
is you can select here and let's say it's employee six and then let's choose
October October and let's say he's starting on October 5th and so then you
go enter date and then Siri this is why we have it going further you go back to
what actually let's go let's go down to October here and you can see that you're
your new employee has started on October 5th and you're your totals of all the of
all your different shifts are now included in that so that's how you enter
shifts rotating shifts from a start date please subscribe