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
123456789
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