Auto populate column titles?


Hi all,

I've recently taken over a sheet from a co-worker who left the company. This sheet is used to track which employee is out of office on weekdays and which employees are covering their particular work duties. The previous manager had populated the column out to 1/14/20. Now that we are approaching this date, I need to extend the calendar out and am wondering if there is any way to do so without having to manually rename each column to a date (i.e., 1/15, 1/16, and so on). Here is an image that will hopefully give you an idea if what I am trying to do. If this isn't feasible, I'm open to any ideas you have for making this more efficient. Thanks!

Best Answer