How to replace a date, change May to June keeping numerical dates

D

dolphinks72002

I have dates set up in a spreadsheet & would like to know how to change the
month portion keeping the numerical portions so I can copy the sheet & just
change the month without having to reformat the whole sheet.
 
N

nastech

Hi, not sure what format month is in, maybe can use find replace to replace
all:
May with June (binocular button, or edit, find..)
 
Top