Which gives the correct answer and is simple. The solution that I have finally found is: F1 =N($A$1) - DATE(2000 1 1) 6391 Has not worked neither has: E1 =DATEVALUE(CONCATENATE(CHAR(34) TEXT($A$1 'DD/MM/YYYY') CHAR(34)))-DATE(2000 1 1) What I take for a correct rendition of the original formula D1 =DATEVALUE(CONCATENATE(CHAR(34) $A$1 CHAR(34)))-DATE(2000 1 1) In my tests C1 does not display an error but a date as a result, only that it is an incorrect one.

It originated when trying to evaluate the formulas in one cell such as B1: Cell content displayī1 =DATEVALUE($A$1) - DATE(2000 1 1) Err:502Īs A1 is an input cell for dates (in an astronomical spreadsheet) I did not understand in the beginning the reason for aplying to it the datevalue() function, which seemed redundant, but I tried in any case to make it work, as the apparently most direct solution (given that the goal was just to perform an arithmetical operation with dates) C1 =$A$1 - DATE(2000 1 1) #VALUEĭid not work in the document (which was imported from an Excel original). Thanks very much.īut unfortunately I have not been able to solve my initial problem just with the correct syntax.

I am sorry for the mistakes in my previous message and you are surely right in your criticisms, Axel.

Err 502 openoffice