Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Problems when using Date() function.
On Mon, 3 Jun 2013 14:05:23 -0700 (PDT), Jan Kronsell wrote:
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 I cannot find any direct limitation information, but HELP does indicate that the digit is an integer. Perhaps that is why. To accomplish the same result as what you are showing, you could use one of these formulas: If the starting date will always be 1 Jan 1900 =A1+1 If the starting date could be some other date, a variation on: =DATE(1900,1,1) + A1 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date problems | Setting up and Configuration of Excel | |||
Date problems | Excel Programming | |||
date problems | Excel Discussion (Misc queries) | |||
Function-Date Problems | Excel Worksheet Functions | |||
Date Problems | Excel Programming |