Microsoft Excel - I need a complex IF function to return correct month based on a variable start date?

Asked By Jonathan Holbrook on 19-Apr-13 11:10 AM

I'm working on revamping a budget and part of the addition is to have an option to set a start date of the budget that automatically adjusted other tabs. But in setting up the budget this way I have ran into an issue of budgeted expenses.

I want to have a drop down list of months to choose from and whatever month is chosen falls under the correct month listed below(that is linking from another tab and isn't an actual date).

As a temporary solution, I set the months to A,B,C list and labeled the beginning month to be "A" and so forth. But it would make it much more user friendly if I can have the drop down list actually be a month instead of an alphabetical value.

Below is my work sample:

https://www.dropbox.com/s/q1gbanqqdwuxrcr/Budget%20Template-Expense%20Tab.xlsx

Basically I want to have Jan,Feb,Mar in column I instead of A,B,C. The dates in column 21 are linked to a setup page that lets us select a start date for the budget.

Thanks for the help.

Harry Boughen replied to Jonathan Holbrook on 20-Apr-13 01:14 AM
Hi Jonathan,
You could set up a table at say O18:P29 or whereever is appropriate
1  
jan

feb

mar

apr

may

jun
   7 
jul
8   aug

sep
10 
oct
11 
nov
12   dec
And use a formula in A22 etc like
=VLOOKUP(MONTH(A21),$O$18:$P$29,2)
to get the text that you want.
Regards
Harry
Harry Boughen replied to Jonathan Holbrook on 20-Apr-13 01:22 AM
Hi again Jonathan,
Another way without the table is to use
=TEXT(DATE(2000,MONTH(A21),1),"mmm")
Regards
Harry