Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenSun, 18 Jan 2015 04:50:56 +0100Working formula in OpenOffice Calc does not work in LibreOffice Calchttps://ask.libreoffice.org/en/question/45100/working-formula-in-openoffice-calc-does-not-work-in-libreoffice-calc/Hi ,
I have a formula in Openoffice Calc that is not working in LibreOffice Calc... can anyone help me make it work?
It is a simple formula to calculate the day of the week from a date:
TEXT(WEEKDAY(DATEVALUE(TEXT(D39&"-"&$Data.K32&"-"&resultsYear,1))),"ddd")
where resultsYear is a RANGE which has a value '2014'.
Data.K32 has the value 'Mar'
D39 is '28'
There appears an Error:502 in the cell.....
OpenOffice gives the correct value of 'Sat'
Thanks in anticipation,
Allan
Anyone?ThompaSun, 18 Jan 2015 04:50:56 +0100https://ask.libreoffice.org/en/question/45100/