Show date as Financial year quarter

Hi How do I show dates as financial year quarter, expressed as FY2014/15 Q1, F/Y2014/15 Q2, FY2014/15Q3 etc. I have attached a spreadsheet that shows a table of the dates for each quarter and a sample list of dates and which quarter they should appear in. Id also like it to return a blank fin the quarter column when there is no data in the date column.

There is no attachment, but it would help if you attached a sample Excel workbook.

To do this, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post.

Don't try to use the Paperclip icon for attachments, as it doesn't work on this forum.

It would also help if you told use which dates the different quarters relate to - is it April to June for Q1 ?

Hope this helps.

Pete

For some reason I cant upload. The quarters are Q1 =1Jul-30Sep, Q2 = 1Oct - 31 Dec, Q3=1 Jan - 31 Mar, Q4 =- 1 Apr - 30 Jun. I would like the result to display as FY nnnn/nn Q1, FY nnnn/nn Q2 etc thanks

Try this in B2:

="FY"&YEAR(A2+184)-1&"/"&TEXT(A2+184,"yy")&" Q"&INT((MONTH(A2+184)-1)/3)+1

then copy down.

Hope this helps.

Pete

Here is another approach:

=TEXT(EDATE(A2,-6),"F\Yyyyy\/")&TEXT(EDATE(A2,6),"yy Q")&CEILING(MONTH(EDATE(A2,-6)),3)/3

@ Pete_UK: your formula stumbles in the end of March, September, and December.

Thanks this works really well, but I don't understand all of the formula.Are you able to step me through it so that I am able to explain it to others? I think I understand what bits of it mean but I'm not sure how to string it together.
Thanks