I have a formula that generates a dates covering a 4 month period:-
=IF(ISNUMBER(VALUE(LEFT(A4,2))),LEFT(A4,2),“0”&LEFT(A4,1))&"/"&IF(MONTH(DATEVALUE(F4&" 1"))<10,“0”,"")&MONTH(DATEVALUE(F4&" 1"))&Current_Year
However once a year this causes problems as the period is December one year to March the next. So my “Current_Year” only covers part of the period.
I thought I would set “Current_Year” to 2024 and tackle December another way.
So I copy Special Pasted December Values into a spare range of cells. I then tried Find and Replace 4 replace by 3. the result was not 03/12/2023 but 03/12/23. Similarly I tried replacing 2024 with 2023 and still get 03/12/23.
When I select the pasted cell I see '03/12/2024
Why won’t Find Replace work?
Any advice please?