Attached is a spreadsheet that includes Day 1 thru Day 7 RT Hours, Day 1 thru Day 7 OT Hours and Day 1 thru Day 7 DT Hours. I need to replace the Day # with dates that are reliant on the Period End Date Inputted (going backwards 7,6,5,4,3,2,1) and rename these column names. Attached is my small workflow because I don't know how to do this and the output I need called outputgood.xlsx.
Thanks in advance for looking at this!
