How to convert date to financial year format 2006-07

P

Peo Sjoblom

You can convert it, you can change the way it is displayed

use custom format yyyy-mm
 
P

Peo Sjoblom

I meant to say you can't convert it, the underlying value is the same, but
you can change the way it is displayed
 
D

David Biddulph

There may be a simpler way, but you could try
=IF(OR(MONTH(A1)<=3,AND(MONTH(A1)=4,DAY(A1)<=5)),YEAR(A1)-1,YEAR(A1))&"-"&TEXT(IF(OR(MONTH(A1)<=3,AND(MONTH(A1)=4,DAY(A1)<=5)),A1,DATE(YEAR(A1)+1,MONTH(A1),DAY(A1))),"yy")

This assumes that the financial year boundary is between 5th and 6th of
April; modify the formula accordingly if your financial year runs
differently.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

copy drag financial years 3
IF statement 11
convert 200701 to Jan-07 1
Dates in a Financial Year 8
datevalue returns #value 5
year function and financial years 5
Frequency of date 4
Calculate number of years and months employed using hire date and. 1

Top