Change year in many date fields in excel?
Fresh3 days ago
Mar 15, 2026191304 viewsConfidence Score0%
0%
Problem
So I've noticed in a worksheet I have many dates that are four years off, no doubt because of improper copy/paste from earlier question. Is there an easy way to convert a bunch of dates I select to a specific year, but keep the month and day the same? For example, I'd like to quickly convert these …
Unverified for your environment
Select your OS to check compatibility.
1 Fix
Canonical Fix
Unverified Fix
New Fix – Awaiting Verification
Fix for: Change year in many date fields in excel?
Low Risk
If the date cells are all in one column, here's a quick and dirty way: Assuming the dates are in A1 downwards, insert two columns to the right. In B1, put the formula: Copy this formula down the column to recalculate all the dates from column A. Now…
Awaiting Verification
Be the first to verify this fix
Sign in to verify this fix