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? ain --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
