- 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?
by wendi78 on May 28, 2020
by cuong on May 27, 2020
by Ingeborg Hawighorst on May 13, 2020
by Brian Jones (OFFICE) on May 06, 2020