Maybe this:

=TEXT(Y13,"yy")

HTH,
Paul

--

"XP" wrote in message
...
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!