Office Automation & Date Formatting

I need a small automation built that sweeps through the files I work with each week, finds every date field, and forces it into the DD-MM-YYYY pattern. The main pain points are spreadsheets and text-based reports; right now team members enter dates in whatever style they like, which breaks formulas, look-ups, and scheduled mail-merges.

Here’s what will make the solution a success for me:
• A one-click or scheduled routine that scans existing documents and future additions.
• All detected dates rewritten as DD-MM-YYYY, whether they appear in cells, column headers, or embedded text strings.
• A short set-up guide so I can roll the tool out to colleagues without extra coding.

You’re free to choose the technology that fits best—Excel VBA, Python, Google Apps Script, or another lightweight approach—as long as it runs reliably on a typical office PC and can be updated later if we migrate platforms.

Hand over the script, clear usage instructions, and a brief changelog, and I’ll handle the rest.