+ Reply to Thread
Results 1 to 4 of 4

get the next month of a selected month.

  1. #1
    Registered User
    Join Date
    04-28-2021
    Location
    Philippines
    MS-Off Ver
    365
    Posts
    3

    get the next month of a selected month.

    Hello guys,

    I want to get the month after of a selected month. For example, if the selected month is January I want the result to be February. If February then March and so on.

    I have a list of months that a user can select in a particular cell B3, once a month is selected in that cell. The cell in c5 should automatically set to the next month of the selected month.

    I found this formula on the net. But it works the other way around, instead of the next month, it gives the previous month. I tried changing the -1 to +1 and see if it works but it doesn't instead it only returns the selected month. Anyone can help me? Thanks a lot in advance.

    =TEXT((1&B3)-1,"mmmm")

  2. #2
    Forum Guru
    Join Date
    02-27-2016
    Location
    Vietnam
    MS-Off Ver
    2016
    Posts
    5,891

    Re: get the next month of a selected month.

    Try this:

    =TEXT((1&B3)+31,"mmmm")

  3. #3
    Registered User
    Join Date
    04-28-2021
    Location
    Philippines
    MS-Off Ver
    365
    Posts
    3

    Re: get the next month of a selected month.

    Quote Originally Posted by Phuocam View Post
    Try this:

    =TEXT((1&B3)+31,"mmmm")
    Thanks a lot. I tried this and it works.

  4. #4
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,006

    Re: get the next month of a selected month.

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

    Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Need formula to calculate days used in month initiated in previous and selected month
    By Ochimus in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-14-2021, 05:54 AM
  2. [SOLVED] Return Month-on-Month growth using current month-prior month/prior month per country
    By losincog in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-21-2020, 05:37 AM
  3. [SOLVED] Formula to calculte previous month name from current month selected
    By MattExcelLearner in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-22-2020, 04:32 AM
  4. Autosum every three months based on month selected - Show three month trend
    By whatever 2233 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-04-2018, 07:43 PM
  5. [SOLVED] Auto instert Month names for This month, Last month and Next month
    By hemal89 in forum Word Programming / VBA / Macros
    Replies: 4
    Last Post: 12-10-2013, 12:01 PM
  6. [SOLVED] Display the first date of the month when the month and year are selected
    By john dalton in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-05-2013, 11:59 AM
  7. [SOLVED] Excel month dropdown list to generate day of week and date for selected month
    By aaaaaaaa in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-17-2010, 02:45 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1