In libreoffice calc, I am trying to use the following formula to return a number for the day of the week so that I can format the cell to show the day (e.g. Friday), but instead I get #VALUE! in the cell:
Sheet 2 cell A1 contains the following, in ‘date format’: 28-03-2021
The weekday function does not work when using referenced cells but works when using the text within the formula as shown below:
What am I doing wrong?