Financial Year Date Conversion How do I change a date into a Financial Year format?
i.e. 30/06/2016 into 2015/2016
Asked
Active
Viewed 65 times
-3
-
2You should ask the question and then answer it yourself below, rather than in the question. – Tim Biegeleisen Jul 01 '16 at 01:13
-
1http://stackoverflow.com/help/self-answer – Michael Benjamin Jul 01 '16 at 01:30
-
thanks for the advice, I'll take note! Not sure why you have down rated the post. Being EOFY, it's a fitting QnA. Cheers! – Josh Seabrook Jul 01 '16 at 01:38
-
@JoshSeabrook your question sounds good, but you should beef your question out, and post the answer as an answer rather than the comments :) – Quill Jul 01 '16 at 01:48
-
@Quill - Thanks! I'm currently at work doing financial year analysis and thought I'd quickly give this a go for a first time! – Josh Seabrook Jul 01 '16 at 02:04
1 Answers
1
Copy+Paste this into a new Cell:
=IFERROR(IF(MONTH(N3)>=7,CONCATENATE(YEAR(N3),"/",YEAR(N3)+1),CONCATENATE(YEAR(N3)-1,"/",YEAR(N3))),"Issue With Date in Cell N3")
New Date: "2015/2016"
Change Cell N3 to cell with your date. Make sure the cell is in a "General" format.
Josh Seabrook
- 13
- 5
-
It seems a perfectly good answer to me, assuming your FY ends in June. – Tom Sharpe Jul 01 '16 at 07:38