- last edited on
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. and want to only change the month from Jan to Feb like this: 2/2/18, 2/5/2018 etc. Any ideas?
06-25-2018 05:26 AM - edited 06-25-2018 05:27 AM
lets say your data are in Col A
you can use this formula below
then format your cells to date format
06-25-2018 05:27 AM
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
when Ctrl+H and replace 01/ on 02/
06-25-2018 05:36 AM
Thanks, but Find and Replace won't work because I have several dates within the column.
06-25-2018 05:40 AMSolution
If you select all your dates before Ctrl+H when Replace All shall work, otherwise find (and replace) one by one
06-25-2018 05:53 AM
03-02-2019 09:46 AM
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?