📁 Daily Folder Tool

Copy yesterday's day-folder → rename it to today → re-date the file names → drop the PDFs.

1Pick the month folder

Choose the folder that contains the day folders — e.g. 2026 Aug Stats, not 07-08-2026.

2Check the plan

—

3What will happen

NowAfterWhat







  
4Or just use the .bat (works on any locked-down PC)

  
    
    
  1. Download daily-folder.bat and put it inside the month folder, next to the day folders.
    2. 
    
  2. Double-click it each morning. It finds the newest day folder by itself, works out today's date, and asks Y before touching anything.
    3. 
    
  3. Nothing is installed and the old folder is never modified.
    4. 
  

  

    
    
  







  
5The date inside the Excel files

  

    Steps 1–4 only fix folder and file names. This step fixes the date written in the sheets —
    title cells, real date cells, formulas, text boxes and print headers. It drives Excel itself, so macros
    (.xlsm), formatting and charts survive; macros are disabled while it runs but stay in the file.
  

  
    
    
  1. Put update-dates.ps1 and update-dates.bat in the month folder, next to daily-folder.bat.
    2. 
    
  2. Once both are there, daily-folder.bat offers this as step 4 — just answer Y. To run it on its own later, double-click update-dates.bat.
    3. 
    
  3. It lists every change it found — file, sheet, cell, before → after — and asks before saving. Nothing is written until you say Y.
    4. 
    
  4. If the PC has a slow network printer, run it as update-dates.bat -SkipHeaders.
    5. 
  

  
  

    
    
  





Runs entirely on your machine · no upload, no network, no install