Excel Calendar for 5x8 Schedule

Hello,

I have designed a perpetual calendar for 5 teams on duty throughout the year on an A4 Excel sheet. You simply need to change the year and everything is done automatically (programmed in VBA).
To meet your request, could you provide me with more information about your choice, namely:
1) Is it a single sheet including the 5 teams, with the shifts distinguished by colors (Morning in Yellow, Afternoon in Red, Night in Blue, Rest in White): in this case, I would simply need the start dates of the morning shifts beginning on the Monday morning for each team and to know the frequency of the rest days.
2) Is it a sheet in the form of a daily agenda corresponding to the teams on duty?
My passion is programming in VBA and everything related to computing, so I have no problem adapting an Excel sheet according to your choices.
Best regards
Jacky

Good evening, do you still want a calendar for the 5x8 work schedule?

Hello,
Jacky, if you can get me this editable 2/2/2 calendar for each year, that would be great because I’ve been looking for one for many years.
I do 2 mornings, 2 afternoons, 2 nights, and 4 days off in 5 teams. I can send you a copy of this year's calendar if you want.
Thanks.

If I didn't mess up during the file transfer, here's a link that will allow you to download an Excel sheet with an annual calendar.

http://ww1.dwlup.com/?subid1=247fb8da-37c7-11eb-942e-9c9fe4538bc7

There you go!

Yes, still interested!

Jean

Thank you, I'll take it too...

Jean

Hi,
sorry, I no longer use Excel.
But there is a free version available at axelren.free.fr.

There is also the website http://www.mesheures.com that does this for free with 3 types of customizable schedules.

It's more like 6x4
6 days worked 2 mornings 2 afternoons 2 nights 4 days off right?

I received this message today, December 21, 2012, at 8:48 PM for 12/21/12 at 12:33 AM.

Despite the Mayan calculations, arithmetic does not change, so neither do the Excel sheets.

if you want Windows Office https://www.01net.com/telecharger/windows/Bureautique/editeur_de_texte/fiches/102701.html