+ Reply to Thread
Results 1 to 5 of 5

Excel formula to understand month+1 is the next month

  1. #1
    Registered User
    Join Date
    01-22-2021
    Location
    Europe
    MS-Off Ver
    2012
    Posts
    18

    Excel formula to understand month+1 is the next month

    Hi,

    I have a list of months written in letters in a drop-down list. Let's say the list is in a cell A1. Now I would need to write a formula that would understood that for example January (selected from the drop-down list in A1) +1 would be February. Do you have any idea is it somehow possible to write this kind of formula in Excel?

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2003,2007,2010
    Posts
    33,816

    Re: Excel formula to understand month+1 is the next month

    I'm sure there's a better way but, in the meantime, try:

    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Note: the MATCH list has 12 entries, January to December, whereas the CHOOSE list has 13 entries, January to January to catch December returning 12. The first "January" entry needs to be there but it can be any value as it will never be picked.
    Trevor Shuttleworth - Excel Aid

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2003,2007,2010
    Posts
    33,816

    Re: Excel formula to understand month+1 is the next month

    One alternative is a simple lookup table ... January to December with matched entries February to January.

  4. #4
    Registered User
    Join Date
    01-22-2021
    Location
    Europe
    MS-Off Ver
    2012
    Posts
    18

    Re: Excel formula to understand month+1 is the next month

    Hi TMS, I got it work with your code! Thank you so much for helping me, you're great!!

  5. #5
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2003,2007,2010
    Posts
    33,816

    Re: Excel formula to understand month+1 is the next month

    You're welcome. Thanks for the rep.

+ 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. Replies: 4
    Last Post: 09-04-2020, 04:02 PM
  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] Excel formula if month passed or running then the month name else blank
    By Neilesh Kumar in forum Excel General
    Replies: 13
    Last Post: 12-03-2018, 01:23 PM
  4. [SOLVED] Calculation of days per month for dates beginning in one month and ending in another month
    By Fahrettin in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 12-07-2015, 04:52 PM
  5. [SOLVED] Determine work days in current month or next month based on day of the month
    By sbrnard in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 05-29-2014, 05:14 PM
  6. [SOLVED] Counting & summing formula (until last month,this month,until this month..
    By Jhon Mustofa in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-12-2014, 01:14 PM
  7. [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

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