Using the YEAR() function can yield a strange result.
To get the year from a date, make sure the value is in a valid date format such as 2023-07-29.
Help page on using the YEAR function
https://help.libreoffice.org/latest/e...
Help page on using the DATEVALUE function
https://help.libreoffice.org/latest/e...
#LibreOfficeCalc