Share via

Automatically change month only in a list of dates

Anonymous
2021-04-19T13:38:36+00:00

I would like to change the month only in a list of dates ie 01/04/2021 to 01/05/2021 or whichever month I choose. Every month I have certain transactions on the same day  and have to painstakingly change the month number. Can I do this automatically and save myself the time.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
  1. Anonymous
    2021-04-19T14:17:15+00:00

    Hi Ray

    Here two possible solutions

    Option 1) Using the formula =EDATE(A1,1)

    Option 2 )  Using Find and Replace in Excel

    1. Select the date list/range cells

    2) Go to Find and Select >> and choose >> Replace  (or simply press the shortcut CTRL+H)

    1. Replace /4/   with /5/   (i.e. the Month)
    2. Replace All

    Do let me know if you need more help

    On the other hand,

    If the answer helped you.

    Please, consider marking this thread as answered.

    It would help others in the community with similar questions or problems.

    Thank you in advance

    Regards

    Jeovany

    3 people found this answer helpful.
    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2021-04-19T14:20:12+00:00

    Hi

    My name is André. I am an independent consultant.

    >you can use the find and replace option.

    I hope this information is useful for you. If you still have questions, answer here so I can continue helping you.

    André.

    0 comments