Formula - Value if True not returning valid year

[tlc53]

Hi there,

I have a formula which the "Value if True" result is not calculating correctly.

For example, if the date in cell D7 is 30/06/18 return 2016-17 but if the month of cell D7 is December, return the year of D7 minus 1 year.

The bit that doesn't seem to be working is YEAR(D7)-1
This returns 1905 instead of 2017.

=IF(MONTH(D7)=12,YEAR(D7)-1,TEXT(DATE(YEAR($D$7)-2,MONTH($D$7),DAY($D$7)),"yyyy")&TEXT(DATE(YEAR($D$7)-1,MONTH($D$7),DAY($D$7)),"-yy"))

Can someone see where I am going wrong please?

Thank you!

 

[Tetra201]

Try formatting the cell with your formula General.

 

[tlc53]

Eureka! Thank you