ExcelBanter - How do I get a calendar that advances each day in excel?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How do I get a calendar that advances each day in excel? (https://www.excelbanter.com/excel-discussion-misc-queries/105056-how-do-i-get-calendar-advances-each-day-excel.html)

Nat

How do I get a calendar that advances each day in excel?

I am working on a staff management spreadsheet and need a work week calendar
that advances to the left each day and then that column that is removed
(which would be yesterday) would be put into a continually advancing archive
worksheet. Any idea?

All times are GMT +1. The time now is 11:17 PM.