On 02/12/09 17:58, Ain Vagula wrote:
date serial number 11274306 gives result 31.12.32767, when cell is
formatted as date
next number, 11274307 gives result 01.01.-32768, year is negative?
More interesting results:
number date=day() function
123456789027.01.-25840 31
12345678916.03.1223331
12345678 25.04.-29835 31
11274307 01.01.-32768 31
11274306 31.12.3276731
11274303 28.12.3276731
123456 03.01.2238 3
1234518.10.1933 18
Why some years turn to negative?
See issue 75335, but note that it's prio 4.
Niklas
-
To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org
For additional commands, e-mail: dev-h...@sc.openoffice.org
