[sc-dev] date serial number conversion

2009-02-12 Thread Ain Vagula
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

Re: [sc-dev] date serial number conversion

2009-02-12 Thread Niklas Nebel
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