Update Google Sheets Dates 2026

I have two Google Sheets that my team relies on to capture leads and monitor sales results. Every formula, pivot, and chart inside them is tied to 2025; I now need everything rolled forward so the files work seamlessly for 2026.

You’ll review each sheet, update every date-dependent formula, extend all ranges, and adjust any hard-coded dates inside the scripts. While you’re in there, please convert any 2025-specific date formats to their 2026 equivalents so future sorting and filtering stay clean.

Deliverables:
• Updated formulas, ranges, referencing 2026
• Consistent 2026-appropriate date formats across every tab
• Quick validation that lead capture and sales KPIs still calculate accurately after the changes

Once done, I should be able to drop 2026 data in and watch the dashboards update without errors or manual tweaks.

Watch video overview here:
https://www.loom.com/share/7f089180e0a149d89840028782cd2a81

Begin your proposal with the word Sheet so I know you are not a bot, please do not attempt to contact me outside of the freelancer platform, thanks Ben :-)