| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Fiscal year - April to March
My company's fiscal year runs from April through March.
So I would like to take a date, say in A1, and convert to Quarter in column B. i.e., 4/1/2010 - 6/30/2010 = Q111 7/1/2010 - 9/30/2010 = Q211 10/1/2010 - 12/31/2010 = Q311 1/1/2011 - 3/31/2011 = Q411 I have read several posts and threads and tried various formulas..with partial success. Thank you for any guidance on this. Brian |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| fiscal year calculation | Excel Discussion (Misc queries) | |||
| calendar year versus fiscal year | Excel Discussion (Misc queries) | |||
| Help dealing with a fiscal year rather than a calendar year | Excel Worksheet Functions | |||
| Birthdate as fiscal year | Excel Discussion (Misc queries) | |||
| Fiscal Year Calculation | Excel Worksheet Functions | |||
Linear Mode
