DATEVALUE

Returns the internal date number for text in quotes.

The internal date number is returned as a number. The number is determined by the date system that is used by LibreOffice to calculate dates.

If the text string also includes a time value, DATEVALUE only returns the integer part of the conversion.

แƒกแƒ˜แƒœแƒขแƒแƒฅแƒกแƒ˜

DATEVALUE("แƒขแƒ”แƒฅแƒกแƒขแƒ˜")

แƒขแƒ”แƒฅแƒกแƒขแƒ˜ แƒแƒ แƒ˜แƒก แƒ›แƒแƒ แƒ—แƒ”แƒ‘แƒฃแƒšแƒ˜ แƒ“แƒ แƒแƒ˜แƒก แƒ’แƒแƒ›แƒแƒกแƒแƒฎแƒฃแƒšแƒ”แƒ‘แƒ, แƒ แƒแƒ›แƒ”แƒšแƒ˜แƒช แƒ‘แƒ แƒญแƒงแƒแƒšแƒ”แƒ‘แƒจแƒ˜ แƒฃแƒœแƒ“แƒ แƒฉแƒแƒกแƒ•แƒ—.

แƒ›แƒแƒ’แƒแƒšแƒ˜แƒ—แƒ˜

=DATEVALUE("1954-07-20") yields 19925.