Using Nested Month Function

[jmripley]

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.

 

[T. Valko]

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)

use a "nested Month function" to return the month for each quarter. This is where I am stuck.

Or, maybe I'm just not understanding what you want to do.

Can you proivde more info and include a sample with the result you expect?

 

[jmripley]

The instructions say "Use a nested Month function to convert the date to a numerical month. Adapt the above VLOOKUP syntax for this calculation" where the above syntax refers to =VLOOKUP(MONTH(A2),Quarters,2) & Quarters refers to a 2 column table as listed in the above posting. Yes this is for school, but have not received a reply from my instructor.

 

[T. Valko]

The instructions say "Use a nested Month function to convert the date to a numerical month. Adapt the above VLOOKUP syntax for this calculation" where the above syntax refers to =VLOOKUP(MONTH(A2),Quarters,2) & Quarters refers to a 2 column table as listed in the above posting. Yes this is for school, but have not received a reply from my instructor.

OK, then I think you've already accomplished that.

The MONTH function within the VLOOKUP function is doing just this:

"Use a nested Month function to convert the date to a numerical month. Adapt the above VLOOKUP syntax for this calculation"

 

[jmripley]

This function gives the corresponding quarter, but not the numerical month. I am understanding it as they are asking for the actual month? Maybe I have misunderstood?

 

[T. Valko]

This function gives the corresponding quarter, but not the numerical month. I am understanding it as they are asking for the actual month? Maybe I have misunderstood?

Maybe this...

A2 = some date

=MONTH(A2)

Will return a number from 1 to 12.