convert 2018 to 18 with =year(today())

[Bandito1]

Hi all,

Im using this formula;

Please Login or Register  to view this content.

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?

[AliGW]

Try this:

=RIGHT(YEAR(TODAY()),2)

[Bandito1]

Works perfectly, thank you very much!

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.