| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Financial Year Month Number
Hi there,
I'm trying to find a formula that returns the month in the financial year, eg October is month no 4, but the month() function returns the month no in the calendar year. Thanks in advance |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Financial Year Month Number
Tiffany wrote:
Hi there, I'm trying to find a formula that returns the month in the financial year, eg October is month no 4, but the month() function returns the month no in the calendar year. Thanks in advance =CHOOSE(MONTH(A1),7,8,9,10,11,12,1,2,3,4,5,6) |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Financial Year Month Number
Thanks
Sorry I posted twice, but I got an error msg saying the first one didn't post "Glenn" wrote: Tiffany wrote: Hi there, I'm trying to find a formula that returns the month in the financial year, eg October is month no 4, but the month() function returns the month no in the calendar year. Thanks in advance =CHOOSE(MONTH(A1),7,8,9,10,11,12,1,2,3,4,5,6) |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Financial Year Month Number
On Tue, 20 Jan 2009 14:00:05 -0800, Tiffany
wrote: Hi there, I'm trying to find a formula that returns the month in the financial year, eg October is month no 4, but the month() function returns the month no in the calendar year. Thanks in advance IF October is 4, then with a date in G1: =MOD(MONTH(G1)-7,12)+1 In general: =MOD(MONTH(G1)-month_1_number,12)+1 --ron |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Finding the Financial Year Month Number | Excel Worksheet Functions | |||
| How to get month number for fiscal year starting in Oct. | Excel Worksheet Functions | |||
| Can I convert a number(1-365) to a month and day of a year? | Excel Worksheet Functions | |||
| convert number to month and year in formula | Excel Worksheet Functions | |||
| countif number of occurences per month per year. | Excel Worksheet Functions | |||
Linear Mode
