View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jan Kronsell[_5_] Jan Kronsell[_5_] is offline
external usenet poster
 
Posts: 10
Default 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