Change date by one year

O

Oldjay

I have a list of birthdays formulated 8/12/05
I want to change all the dates to next year i.e. 8/12/06

oldjay
 
R

Roger Govier

Or, for a "quick and dirty" solution
Ctrl+h to bring up Find and Replace
Find What /2005
Replace with /2006
Replace all

Regards

Roger Govier
 
Top