[FAQ000124]Is it possible to display the date in yymmdd format?¶
Q¶
In CELF, is it possible to display the date in yymmdd format?
A¶
It can be displayed by converting it using the YEAR function, RIGHT function, etc. as shown below.
=RIGHT(YEAR(A1),2)&IF(MONTH(A1)<10,"0","")&MONTH(A1)&IF(DAY(A1)<10,"0","")&DAY(A1)
For example, if the value in cell A1 is "April 1, 2019", the result of the above formula will be "190401".
A list of functions available in CELF is provided below.
Related keywords¶
User definition, Format