2013. december 17.

Libreoffice Functions

date to text:

this is in A1: 04/30/13
want it to look like this: 2013-04

the function is: =YEAR(A1)&"-"&TEXT(MONTH(A1),"00")

Nincsenek megjegyzések: