Page 1 of 2 12 LastLast
Results 1 to 10 of 15

Using Nested Month Function

This is a discussion on Using Nested Month Function within the Excel Questions forums, part of the Question Forums category; My instructions tell me to use a "nested month function" to convert the date to a numerical month, using a ...

  1. #1
    New Member
    Join Date
    Jul 2012
    Posts
    6

    Default Using Nested Month Function

    My instructions tell me to use a "nested month function" to convert the date to a numerical month, using a VLOOKUP syntax. I have already used the formula =VLOOKUP(MONTH(A2),Quarters,2) in the cell. I'm not familiar with these functions, so any help is greatly appreciated. Thank you.

  2. #2
    Board Regular
    Join Date
    Jul 2006
    Location
    Brussels
    Posts
    7,720

    Default Re: Using Nested Month Function

    Hello

    What is the contents of "Quarters"?
    Regards,

    Wigi

    http://www.wimgielis.be

    Excel MVP 2011-2014

  3. #3
    New Member
    Join Date
    Jul 2012
    Posts
    6

    Default Re: Using Nested Month Function

    Quote Originally Posted by wigi View Post
    Hello

    What is the contents of "Quarters"?

    Quarters has four cells = Quarter1 Quarter2 Quarter3 Quarter4 (in reference to the quarters in a year).

  4. #4
    Board Regular
    Join Date
    Jul 2006
    Location
    Brussels
    Posts
    7,720

    Default Re: Using Nested Month Function

    What is the result of the VLOOKUP ?
    Is this what was asked in the instructions ?
    Regards,

    Wigi

    http://www.wimgielis.be

    Excel MVP 2011-2014

  5. #5
    Board Regular
    Join Date
    Jun 2005
    Location
    London
    Posts
    6,397

    Default Re: Using Nested Month Function

    If you want to convert a date into a quarter, you can use:
    ="Quarter "&ROUNDUP(MONTH(A1)/3,0)
    Neil

  6. #6
    Board Regular T. Valko's Avatar
    Join Date
    May 2009
    Location
    Pittsburgh
    Posts
    16,133

    Default Re: Using Nested Month Function

    Quote Originally Posted by jmripley View Post
    Quarters has four cells = Quarter1 Quarter2 Quarter3 Quarter4 (in reference to the quarters in a year).
    Quarters (as a named range) would need to be a 2 column range like this (for purposes of demonstrating how VLOOKUP works):

    Sheet1

     ABCDE
    1DateQuarter_MonthQuarter
    27/18/2012Quarter3_1Quarter1
    3___4Quarter2
    4___7Quarter3
    5___10Quarter4



    Quarters refers to: =$D$2:$E$5

    Your formula entered in B2:

    =VLOOKUP(MONTH(A2),Quarters,2)
    .
    Biff
    Microsoft MVP - Excel

    Using Excel 2002, 2007
    KISS - Keep It Simple Stupid

  7. #7
    New Member
    Join Date
    Jul 2012
    Posts
    6

    Default Re: Using Nested Month Function

    Yes this is how the table looks:

    Breakpoints Quarter
    1 Quarter 1
    4 Quarter 2
    7 Quarter 3
    10 Quarter 4

  8. #8
    Board Regular T. Valko's Avatar
    Join Date
    May 2009
    Location
    Pittsburgh
    Posts
    16,133

    Default Re: Using Nested Month Function

    Quote Originally Posted by jmripley View Post
    Yes this is how the table looks:

    Breakpoints Quarter
    1 Quarter 1
    4 Quarter 2
    7 Quarter 3
    10 Quarter 4
    OK, does your formula not return the correct result? If not, then what date do you have in cell A2 and what result do you get?
    .
    Biff
    Microsoft MVP - Excel

    Using Excel 2002, 2007
    KISS - Keep It Simple Stupid

  9. #9
    New Member
    Join Date
    Jul 2012
    Posts
    6

    Default Re: Using Nested Month Function

    My result is correct to return the Quarter, but they are now asking to use a "nested Month function" to return the month for each quarter. This is where I am stuck.

  10. #10
    Board Regular T. Valko's Avatar
    Join Date
    May 2009
    Location
    Pittsburgh
    Posts
    16,133

    Default Re: Using Nested Month Function

    Quote Originally Posted by jmripley View Post
    My result is correct to return the Quarter, but they are now asking to use a "nested Month function" to return the month for each quarter. This is where I am stuck.
    Well, the lookup formula does contain a nested MONTH function as does the suggestion by Neil in post #5.

    So, "nested Month function" is really ambiguous and open to interpretation.

    Is this a school exercise? If so, then you may want to get more guidance on what you are expected to do with this.

    There are many ways to get the calendar quarter from a date. Here are a couple:

    A1 = some date

    =CEILING(MONTH(A1)/3,1)

    =INT((MONTH(A1)+2)/3)
    .
    Biff
    Microsoft MVP - Excel

    Using Excel 2002, 2007
    KISS - Keep It Simple Stupid

Page 1 of 2 12 LastLast

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com