Forum Discussion
Solved
Change month only in a column containing several rows of dates
Apologize if this has been solved previously. I am attempting to change the month only in a column of already entered dates in a column. For example I have 1/2/2018, 1/5/2018, 1/17/2018, 1/20/18 etc...
If you select all your dates before Ctrl+H when Replace All shall work, otherwise find (and replace) one by one
Hi John,
If we speak only about Jan to Feb, not every month in dates on next one, I'd first apply to your dates custom format
mm/d/yyyy
when Ctrl+H and replace 01/ on 02/
I tried to replace jan to feb. (ex. 1/1/19 to 2/1/19). When doing so, the day also changed to 2? I only want to change the month. using 1/ to 2/ will also change the day if it has 1/. How can I only change the month using the replace function?