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
1234567890 27.01.-25840 31
123456789 16.03.12233 31
12345678 25.04.-29835 31
11274307 01.01.-32768 31
11274306 31.12.32767 31
11274303 28.12.32767 31
123456 03.01.2238 3
12345 18.10.1933 18
Why some years turn to negative?
See issue 75335, but note that it's prio 4.
Niklas
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
