Forum Discussion

mhristau's avatar
mhristau
Copper Contributor
Oct 04, 2023
Solved

Date 00/00/00 change year only

Have a column of dates with the wrong year: ??/??/22 need to change the year to ??/??/21 I've formatted the column to Text. Selecting the column to limit Find How do I Find the /22 year instances...
  • HansVogelaar's avatar
    HansVogelaar
    Oct 05, 2023

    mhristau 

    Let's say you have dates in D2 and down.

    In E2:

    =DATE(2023, MONTH(D2), DAY(D2))

    Fill down.