Problems when using Date() function.
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
|