Date Formating to text ( YEAR 1, Year 2 etc)

[Dan4889]

Hi Guys,

I am new and just have a question in regards to formatting dates into specific text.

I want to create a formula for example 01/02/2019 will display in a row above "YEAR 1" and then 01/03/2020 will display as "YEAR 2".
If anyone has any suggestions it would be great. i have 12 rows for each year and month.

If anyone knows the formula to do this it would be great. I also have the excel file

Many Thanks

 

[sadboy309]

You use Function and copy down it.

="Year " & YEAR(D1)-2018