Forum Discussion
looking for a fast way to auto update the year on this formula to 2023
I do my monthly inventory bookkeeping in excel and at the end of the year I am left with formulas that pertain to only that year and have been going in and manually changing each date to reflect the ...
Press Ctrl+H to activate the Replace dialog.
If necessary, click 'Options >>'.
Set Within to Workbook, and make sure that 'Look in' is set to Formulas, and that 'Match entire cell contents' is not ticked.
Enter 2022 in the 'Find what' box and 2023 in the 'Replace with' box.
Click 'Replace All'.
Next, enter 2021 in the 'Find what' box and 2022 in the 'Replace with' box.
Click 'Replace All'.
That should do it.
perfect. thank you
