firefighter345
New Member
- Joined
- Nov 2, 2016
- Messages
- 4
I am a firefighter and work with excel a couple of times a year. One specific instance is I "build" our Kelley day schedule... it is a long painful process and it takes quite a bit of time. I am hoping someone can show, tell or teach me how to setup the document to autofill when one date is input. A little info may help this proceed and I will (if I can figure it out) post a screen shot of a current schedule.
So here is how it works we work every third day so I work Sunday, Wednesday and Saturday one week, Tuesday, Friday the next and then Monday, Thursday before it starts all over at Sunday. We are forced to take a day off every 6 weeks on a day we choose the year prior. So for example every 6th Monday in 2016 I have off and that started in January 4th so this year I had the following days off Jan 4, Feb 15, Mar 28, May 9, June 20, Aug 1, Spet 12, Oct 24 and Dec 5. I hope this makes sense. Also if it could auto total the number of days in the column that would be great, if not I can handle that quickly enough.
Our 2018 calendar is what I am working to solve the formula(s) for but don't know enough about excel to figure it out. It is or should be formatted identically to this...
[/URL][/IMG]
Thanks in advance for help/suggestions
The first Kelley of the year for my shift in 2018 is Tuesday January 2nd the next would be Friday January 5, Monday Jan 8, continuing every third day
So here is how it works we work every third day so I work Sunday, Wednesday and Saturday one week, Tuesday, Friday the next and then Monday, Thursday before it starts all over at Sunday. We are forced to take a day off every 6 weeks on a day we choose the year prior. So for example every 6th Monday in 2016 I have off and that started in January 4th so this year I had the following days off Jan 4, Feb 15, Mar 28, May 9, June 20, Aug 1, Spet 12, Oct 24 and Dec 5. I hope this makes sense. Also if it could auto total the number of days in the column that would be great, if not I can handle that quickly enough.
Our 2018 calendar is what I am working to solve the formula(s) for but don't know enough about excel to figure it out. It is or should be formatted identically to this...
Thanks in advance for help/suggestions
The first Kelley of the year for my shift in 2018 is Tuesday January 2nd the next would be Friday January 5, Monday Jan 8, continuing every third day
Last edited by a moderator: