![]() |
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