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...
Formulas and Functions
  • 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.

mhristau's avatar
mhristau
Copper Contributor
Oct 04, 2023

HansVogelaar works well, thanks for that

Can you help me with the replace formula?

Replace only the year without changing month/day/year?

HansVogelaar's avatar
HansVogelaar
MVP
Oct 05, 2023

mhristau 

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

In E2:

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

Fill down.

  • mhristau's avatar
    mhristau
    Copper Contributor
    Oct 05, 2023
    Most helpful-Thanks again