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: https://stackoverflow.com/questions/68462223/how-to-change-year-value-in-excel-from-a-date-range

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: