Hi again,

Am Thu, 21 Apr 2016 09:39:10 +0200 schrieb Claus Busch:

=--(TEXT(DATEVALUE("1-04-2016"),"yy")&TEXT(DATEVALUE("1-04-2016"),"MM"))

for me also works:
=--(TEXT("1-04-2016","yy")&TEXT("1-04-2016","MM"))

you also can enter a correct date and format it custom
YYMM


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional