ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Fiscal year - April to March (https://www.excelbanter.com/excel-discussion-misc-queries/267759-fiscal-year-april-march.html)

Brian222

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


All times are GMT +1. The time now is 08:17 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com