Complex IF Function

[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.


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.

 

[Hui]

Whats stopping you adjusting the Data Validation to:

Monthly,Bi-Monthly,Quarterly,Jan,Feb,Mar,Apr,May,Jun,Jul,Aug,Sep,Oct,Nov,Dec

and adjusting the formulas accordingly?

 

[jholbrook]

That's what I originally did, but when I change the budget start date the IF function would return the wrong month. I'd like to keep the budget start date function as we do budgets with different starting months.


SetupC19 is a start date for the budget.