Hi all,
Im using this formula;
It returns the value; dec2018.=TEXT(DATEVALUE(1&'Gel Calc'!B14);"mmm")&YEAR(TODAY())
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?
Bookmarks