Problems when using Date() function.
I discovered myself that the largest number possible is actually 32767, but I still can't find any documentation.
Jan
Den mandag den 3. juni 2013 23.05.23 UTC+2 skrev Jan Kronsell:
I have the following function =Date(1900,1,1+A1) (A1 containing 367) and it returns 02-01-1901 (Danish notation) as expected. If A1 instead contains 41012, I expect it to return 14-04-12 (41013), but it does not. It returns 16-09-89
(32767).
Is there a limitation to the final argument in the Date function, that I'm not aware of and in that case, what is it=
Jan
|