| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Finding the Financial Year Month Number
Hi there,
I'm trying to find a formula to return the month in the financial year, eg Oct is month number 4, but the month() function is based on calendar year. Can anyone help?? Thanks in advance |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Finding the Financial Year Month Number
Hi Tiffany,
There has to be a bettter way but this should work, =IF(MONTH(A1)<7,MONTH(A1)+6,MONTH(A1)-6) HTH Martin "Tiffany" wrote in message ... Hi there, I'm trying to find a formula to return the month in the financial year, eg Oct is month number 4, but the month() function is based on calendar year. Can anyone help?? Thanks in advance |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Finding 3rd (or 2nd) Sunday in a given year/month | Excel Worksheet Functions | |||
| Can I convert a number(1-365) to a month and day of a year? | Excel Worksheet Functions | |||
| Finding the date using the number of the week in a year | Excel Worksheet Functions | |||
| Finding the date on the 'nth' Monday in this Month in this Year | Excel Worksheet Functions | |||
| Finding people born in a given month or after a given year | Excel Worksheet Functions | |||
Linear Mode
