month function issue

[Petrolcb41]

Good day,

My situation is this. I have a sheet that will compute budgets. The issue is that the budget is a quarterly, not monthly and my company's fiscal year goes from November to October.

So basically, i need to set up a formula such that when i enter the month's name into a certain cell say A1 (i.e November), a value will be returned in another cell say A2 based upon that month's number in our the fiscal year. For example, November would yield a 1 not an 11 since it is the first month in our fiscal year, December a 2, not a 12, etc.

I'm working with Excel 2003 so nested If functions are limited.

Any ideas???

Thanks!


- Vin

[Ron Coderre]

With A1 containing a month name...eg October

This formula returns the fiscal month of that value:

Please Login or Register  to view this content.

In the above example, the formula returns: 12

Is that something you can work with?

[alansidman]

Create a table on another sheet and use vlookup. Example attached.

[daddylonglegs]

perhaps try

=MONTH((1&A1)+62)

[Petrolcb41]

With A1 containing a month name...eg October

This formula returns the fiscal month of that value:

Please Login or Register  to view this content.

In the above example, the formula returns: 12

Is that something you can work with?

Ron,

This is awesome....EXACTLY what I needed and it works beautifully. Thanks so much!!!!!!!