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


Gord Dibben MS Excel MVP


On Thu, 10 Jul 2008 08:11:03 -0700, XP wrote:

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!