Hi all,

Im using this formula;

=TEXT(DATEVALUE(1&'Gel Calc'!B14);"mmm")&YEAR(TODAY())
It returns the value; dec2018.

I would like that it returns dec18.
So not the full year but only the last 2 digits. Thought i add "yy" but that doesn't work.

Can someone help me?