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
Jamil,
=EDATE(A1,1)
shall work in such case
Yes Sergei,
that one is even better.
that one is even better.