IF Function Issue

[jholbrook]

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.


I can send the spreadsheet as that would probably help greatly.


Thanks for the help

 

[jason]

yeah, i would upload a sample...

 

[jholbrook]

Here you go.

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.


Thanks!

 

[jholbrook]

The dates in column 21 are linked to a setup page that lets us select a start date for the budget.