How to change Year value in Excel from a date range?

I need to change year according to Fiscal Year.

Data now.  Data should be.
1/1/2021.  1/1/2019
2/3/2021.  2/3/2019
7/1/2021.  7/1/2018

For range 7/1/2021-12/31/2021 year should be changed into 2018. For range 1/1/2021-6/30/2021 year should be changed into 2019. All unchanged data in cell format 7/2/2021.

Any suggestions please.

Read more here:

Content Attribution

This content was originally published by Irina L. at Recent Questions - Stack Overflow, and is syndicated here via their RSS feed. You can read the original post over there.

%d bloggers like this: