| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Dates in a Financial Year
Hi,
Type this in range C9:C12 - 2,5,8,11. Type this in range D9:D12 - Qtr 3,Qtr 4,Qtr 1,Qtr 2. Assuming your date in cell B15, in cell C15, you may use the following formula =VLOOKUP(MONTH(B15),$C$9:$D$12,2)&", "&IF(MONTH(B15)<8,YEAR(B15)-1,YEAR(B15)) Hope this helps. -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Kurt" wrote in message ... If I have a financial year August01-July31, is there a worksheet function(s) which I can use to convert date such as 22/08/09 to read 'Qtr1, 2009' or 23/03/10 to read 'Qtr 3, 2009' etc. Any advice? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Financial Year Weeknum | Excel Discussion (Misc queries) | |||
| Financial Year Month Number | Excel Worksheet Functions | |||
| Pivot Table by Financial Year | Excel Discussion (Misc queries) | |||
| year quarters === Financial Year | Excel Discussion (Misc queries) | |||
| How to compare a date with financial year | Excel Discussion (Misc queries) | |||
![Ashish Mathur[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
