Date formula to return two digit year
=TEXT(Y12,"yy")
"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!
|