How to replace year 2025 to year 2026 in a date column of a spreadsheet?

To replace the year 2025 with 2026 in a date column of a spreadsheet in Excel, you can use the Find and Replace feature. Here’s how to do it:

1. Select the Column: Click on the header of the column that contains the dates you want to change.
2. Open Find and Replace: Press Ctrl + H (or Command + H on Mac) to open the Find and Replace dialog box.
3. Find What: In the "Find what" field, enter 2025.
4. Replace With: In the "Replace with" field, enter 2026.
5. Options: Click on "Options" to expand the dialog if necessary, and ensure that the "Match entire cell contents" option is unchecked so that it replaces the year within the date.
6. Replace All: Click on the "Replace All" button to change all instances of 2025 to 2026 in the selected column.
7. Close: Once the replacements are done, you can close the dialog box.

This method will effectively update the year in your date column without affecting other parts of the dates.

Hi C.K. Tran,

Welcome to Microsoft Q&A Forum.

Thanks for sharing your situation with Excel. I am just checking in to see if the above information was helpful. In case you need more information to troubleshoot this case, you can try the below formula to check it out:

1. Assume your dates are in Column A.
2. In Column B, enter this formula:

      =DATE(2026, MONTH(A1), DAY(A1))
   

3. Drag down to apply to all rows.
4. Copy Column B → Paste as Values over Column A.

If you need to replace multiple years or apply logic (e.g., only change 2025), you can use:

=IF(YEAR(A1)=2025, DATE(2026, MONTH(A1), DAY(A1)), A1)

Please let me know your result after trying.

Thanks, and sincerely,

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".  

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.