How to get last two digit of year?

[ljCharlie]

How do I get the last two digit of e.g. 2005? I did this:

Year(1/25/2005)

and I get 2005 but I want to list it as 05 instead.

Help is appreciated.

ljCharlie

[Leith Ross]

Hello Ljcharlie,

ShortYear = Format("1/25/2005", "yy")

Sincerely,
Leith Ross

[Ron Coderre]

Method 1(retains date value):
Format the date to only display the 2-digit year
Forma>Cells>Number Tab
Category: Custom
Type: YY


Method 2(Coverts value to text):
=TEXT(Year(1/25/2005),"YY")

I'm sure there are other ways, too.

Regards,
Ron

[ljCharlie]

Thank you very much, it works!

ljCharlie

[Satishkumar62]

=right(year(today()),2)

[alansidman]

@satishkumar62
This thread is from 14 years ago. It is highly unlikely the OP is still looking for a solution. Please respond to current situations. Welcome to the Forum. We look forward to your contributions to current issues.

[YFinder]

The thread might be old but the updated code just helped me. people bumping threads with updates is usually the best help because the threads are long since crawled and indexed.

[Diego1]

Very helpful, thank you.

[AZPCP]

Thank you! Exactly what I needed!