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
lets say your data are in Col A
you can use this formula below
=DATE(YEAR(A1),MONTH(A1)+1,DAY(A1))
then format your cells to date format
Jamil,
=EDATE(A1,1)
shall work in such case
This works rather easily! Thanks.
- Hi John,
your select your own comment as best response.
can you please confirm whether the find and replace worked for you?
- Yes Sergei,
that one is even better.
