Weekly Employee Schedule

Copper Contributor

Novice here.

 

Trying to create a calendar for employee schedule that looks like below. 

 

1. Employee selects a date on the Date Picker cell.

2. Dates under the Day of the week changes based on the date picked.

3. Their schedule shows up next to their names based on the date picked. 

 

Date Picker     
 MondayTuesdayWednesdayThursdayFriday
Dates10/1/2210/2/2210/3/2210/4/2210/5/22
Employee 1Location 1Location 3Location 12Location1Location2
Employee 2Location 12Location 31Location 12Location 7Location2
1 Reply

@Erick_Herradura 

 

As of this writing you've had over 60 views with no replies. I'm replying only to tell you that I suspect you will get more of a helpful response if you spell out a bit more here, and maybe even attach a copy of whatever workbook you've created so far. I don't think it will be too difficult to create the functionality you describe; however, it's not just a calendar that is needed. You also must be working with a database or table of data of some sort: WHAT does that look like? Because how the calendar will work will very much be a function of what your source data looks like, what it contains, and how it's arrayed.

 

So please post a copy of your workbook (with real names removed; use something like Disney character names instead). Post it here if you can, but if not here, on OneDrive or GoogleDrive, posting a link here that grants access to your file.