=TEXT Formula for 2022

Hi,

In the attached sample book I cant figure out what to change in my formula in column C so that when the year changes to 22 in column K; it also changes in column C.

I am using the formula in column C so that I don't have to replace the . with / each time I use the data source, I can just copy it in and let the formulas do all the work. (data source is European and I am in the UK so the date format is always with a .)

Any help is much appreciated.

Aarron