Hello,
I have manually created a list of dates in Column E and a list of employees next to the dates in Column E to show which days they work. Currently there are five employees, named in cells A2:A6, and the first employee listed starts on the first Friday of January and works 7 days, on the second Friday the second employee starts and works for 7 days and the pattern repeats itself down throughout the year.
I used the CEILING formula in E7 to determine the first Friday of the month (and year as the dates start in January). What I am looking for is for a formula in F7 that pulls in the first employee in the list and then something to fill out the rest of column F to list the employees names every 7 days, hopefully this formula is also smart enough to recognize a change in the number of employees if so happens in future years. Thanks for the help!
Example of what I currently have:
Friday,January 1,2021 Bob
Saturday,January 2,2021 Bob
Sunday,January 3,2021 Bob
Monday,January 4,2021 Bob
Tuesday,January 5,2021 Bob
Wednesday,January 6,2021 Bob
Thursday,January 7,2021 Bob
Friday,January 8,2021 Joe
Saturday,January 9,2021 Joe
Sunday,January 10,2021 Joe
Monday,January 11,2021 Joe
Tuesday,January 12,2021 Joe
Wednesday,January 13,2021 Joe
Thursday,January 14,2021 Joe
Friday,January 15,2021 Bill
Saturday,January 16,2021 Bill
Sunday,January 17,2021 Bill
Monday,January 18,2021 Bill
Tuesday,January 19,2021 Bill
Wednesday,January 20,2021 Bill
Thursday,January 21,2021 Bill
Bookmarks