How do I create a formula in one column to change by one each month ex: it January and Column one A DOB 2023-01-17 Column B is 12 when I change the month February I want column B to 13 so on and so on. Is this even possible?

Sharron Ammann 0 Reputation points
2024-01-17T21:43:57.47+00:00

How do I create a formula in one column to change by one each month ex: it January and Column one A DOB 2023-01-17 Column B is 12 when I change the month February I want column B to 13 so on and so on. Is this even possible? (Total newbie here)

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,477 questions
Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,645 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Jiajing Hua-MFST 5,070 Reputation points Microsoft Vendor
    2024-01-18T03:07:37.3466667+00:00

    Hi @Sharron Ammann

    For better analysis, I have 2 questions:

    • Will the length of text in column A change? For example, "DOB" changes to be other text with different length instead of 3.
    • If the year becomes 2024, such as 2024-1-27, what's the result you need in column B?

    Currently, I suggest you try formula =VALUE(MID(A2,FIND("-",A2)+1,2))+11 to have a check.

    User's image

    Any updates, welcome to post back.

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment". Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.