On 21/04/2016 01:28 PM, Claus Busch wrote:
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.


Both the formulas work fine.
Thank you, Claus.

Kind Regards,
Ahmed.

---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus