User Profile
alpuckering
Copper Contributor
Joined Oct 22, 2021
User Widgets
Recent Discussions
Re: need help creating a 2023 staffing calendar
First, thank you for taking a look at my request. I really appreciate it. This is the source excel file. All the entries of staff names have been entered manually, and it is a four week rotation. I added in the row of dates, one for each week. I want to repeat this 4 week rotation for the rest of the year, with the proper calendar dates. I hope this makes sense.1.3KViews0likes0Commentsneed help creating a 2023 staffing calendar
I am trying to make a 2023 calendar year Employee Staffing file. I want to be able to auto sort the names alphabetically, and also have the date headline each week without having to manually enter a date in cell A and drag across the row (53 times for each week!). Here's an example of what it looks like now: Sun Mon Tue Wed Thur Fri Sat Week# 1-Jan 2-Jan 3-Jan 4-Jan 5-Jan 6-Jan 7-Jan Charlene Dan Charlene Charlene Charlene Dan Dave 3 Dan Eva Dave Dan Dan Dave John M Ian Evan Eva Dave Dave Evan Linn Kim Grace Evan Eva Eva Grace Lori Simone Jennifer Grace Evan Evan Ian Tim M Jessica Ian Grace Grace Jessica Xcinia John Jennifer Ian Ian John Julia Jessica Jessica Jessica Julia 8-Jan 9-Jan 10-Jan 11-Jan 12-Jan 13-Jan 14-Jan John M Dan Dave Charlene Charlene Charlene Charlene 4 Linn Dave Eva Dan Dan Dan Eva Lori Eva Evan Dave Dave Dave Grace Tim M Evan Grace Eva Evan Evan Jennifer Xcinia Grace Ian Evan Ian Grace Julia Ian Jennifer Grace Jessica Ian Jennifer Jessica Jessica John Jessica pp 15-Jan 16-Jan 17-Jan 18-Jan 19-Jan 20-Jan 21-Jan Charlene Dan Dan Charlene Charlene Charlene Dave 1 Eva Eva Dave Dan Dan Dan Evan Grace Evan Eva Dave Dave Dave Jessica Jennifer Grace Evan Eva Grace Evan Linn Julia Ian Grace Evan Ian Grace Molly Jennifer Jennifer Ian Jessica Ian Stephanie Jessica Jessica John John Jessica John Kim Kim Julia John 22-Jan 23-Jan 24-Jan 25-Jan 26-Jan 27-Jan 28-Jan Evan Dave Dave Charlene Charlene Charlene Charlene 2 Jessica Eva Eva Dan Dan Dan Dan Linn Evan Grace Dave Dave Dave Ian Molly Grace Ian Eva Eva Evan Kim Stephanie Ian Jennifer Evan Evan Grace Simone Jennifer Julia Grace Grace Ian Jessica Kim Jessica Ian John Julia Linn John Jessica Julia pp1.4KViews0likes2Comments
Recent Blog Articles
No content to show