Previous Topic Next Topic

How to change months only in dates

Closed
Desperate - Feb 17, 2010 at 07:53 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Feb 17, 2010 at 11:35 PM
Hello,

I have a spreadsheet that has dates sprinkled throughout the sheet. Unfortunately I have the wrong month and need to change June 10 etc into July 10. In other words ALL the cells with dates that include the month of June in format of 06/10/2010 need to be changed to 07/10/2010.

Is there a way to change only the month of a date but keep the same day and year?

And, change Jun-10 to Jul-10. Again many different days. Only month needs changed.

Any help is greatly appreciated.

1 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Feb 17, 2010 at 11:35 PM
Well if you are lucky and month is such that it can be replaced by search and replace, you can try this

like search for 6/ and replace it with 7/ Just dont do replace all. do one at a time
now if you have 26/ or some thing like that then it would be a lot tricky.
0

Similar discussions

Ig stories from close friends to public
Darren -
zara -

31 responses