Formatting the year to just be the last 2 numbers

[Im_Offset]

How can I get the output of a cell to be just the last 2 numbers of the year?

For Example: Cell A1 has the formula =today()
If I put in cell A2, =year(A1) the result is 2016.

How can I get the output to just be 16 ? A formula that will output the answer as text is fine.

Thanks!

 

[Chihiro]

In A2: =Text(a1, "yy")

 

[Naresh Yadav]

Or...

=RIGHT(YEAR(A1),2)

regards
Naresh

 

[Im_Offset]

Thanks Naresh. that formula is great. But when I try the formula that Chihiro suggested the result is "05". Why is that?

Anyone know???

 

[Chihiro]

Can you upload the workbook where my formula returns "05"? The formula will return "16" as long as this year's date value is stored in A1 (i.e. Today()).

 

[Im_Offset]

Can you upload the workbook where my formula returns "05"? The formula will return "16" as long as this year's date value is stored in A1 (i.e. Today()).

Here it is. In B1 I put the date as =today() In C1 I entered the date as 7/26/16

 

[Chihiro]

Ah, you entered =TEXT(YEAR(B1),"yy")
You don't need YEAR(B1) part. Just enter =TEXT(B1,"yy")

By nesting YEAR(B1) formula becomes =TEXT(2016, "yy")
2016 is taken as Date value (not year) by TEXT function.
Which is interpreted as 7/8/1905, thus returning "05".

 

[David Evans]

=TEXT(B1,"yy") returns 16

 

[Im_Offset]

Aha! Cool. Thanks for the info, I totally understand it. I have learned something