| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I set a year to commence on date other than January 1
I wnat to compare data between year 1 and year 2 etc. in Excel, and I also
need that the year is Oct to Sept. Is there a formula that will conver a date into a Year (or period of 12 months) and identify it as year 1 or year 2 etc. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do I set a year to commence on date other than January 1
I use this formula to show the fiscal year and quarter:
="FY"&YEAR(A1)-(MONTH(A1)<#)&"-Q"&INT(1+MOD(MONTH(A1)-#,12)/3) So if the fiscal year starts on Oct 1st, then I'd use: ="FY"&YEAR(A1)-(MONTH(A1)<10)&"-Q"&INT(1+MOD(MONTH(A1)-10,12)/3) It results in an expression like: FY2009-Q1 If you don't care about the quarter, you an drop that stuff: ="FY"&YEAR(A1)-(MONTH(A1)<10) MPCB wrote: I wnat to compare data between year 1 and year 2 etc. in Excel, and I also need that the year is Oct to Sept. Is there a formula that will conver a date into a Year (or period of 12 months) and identify it as year 1 or year 2 etc. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel reformatting a date axis to January | Charts and Charting in Excel | |||
| why does the date 09/01/07 come up as January 9, 2007? | Excel Discussion (Misc queries) | |||
| using a drop down list to commence a macro | Excel Discussion (Misc queries) | |||
| Format date in excel 2000 like '31st January 2005' | Excel Discussion (Misc queries) | |||
| using date function, month shows as January when i type (12) | Excel Discussion (Misc queries) | |||
Linear Mode
