Date formula to return two digit year

[XP]

I'm trying to perfect a formula that produces a two digit year from another
cell that contains a full date, for example:

Y12 contains the following formatted as a date: 07-10-2008

In Y13 my formula is: =TEXT(YEAR(Y12),"##")

No matter what I try I get: 2008 as a result rather than the intended: 08

I'm sure it is obvious, but can someone please assist. Thanks much in advance!

 

[Dennis]

=TEXT(Y12,"yy")

 

[Dave Peterson]

=TEXT(YEAR(Y12),"YY")

I'm trying to perfect a formula that produces a two digit year from another
cell that contains a full date, for example:

Y12 contains the following formatted as a date: 07-10-2008

In Y13 my formula is: =TEXT(YEAR(Y12),"##")

No matter what I try I get: 2008 as a result rather than the intended: 08

I'm sure it is obvious, but can someone please assist. Thanks much in advance!

 

[PCLIVE]

Maybe this:

=TEXT(Y13,"yy")

HTH,
Paul

 

[Gord Dibben]

Would =TEXT(Y12,"yy") work for you?


Gord Dibben MS Excel MVP

 

[Dave Peterson]

Ignore this response.

I didn't notice the year() portion.

 

[XP]

Yeah, thanks.

It was a case of my adding too much! When I remove the "Year" portion, it
works.

Thanks again.

 

[Rick Rothstein \(MVP - VB\)]

You have your answer (several times now), but I just wanted to mention that
when you use a # or 0 symbol in the integer part of a string pattern, that
does *not* restrict the number of digits in the integer part of the number
being processed, it only differentiates whether leading zeroes will be
printed or not. This is different from the decimal part of a floating point
number where the number of # or 0 symbols in the string pattern does
truncate (actually, round) the number of decimal places printed out. So,
whether you used "#", "##", "###", etc. in the integer part of the pattern
string, you would always have gotten 2008 printed out. As the other
responses showed, using the date part meta-characters in the pattern string
allow you to restrict the part of the date printed out.

Rick