| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
DAYS360
I don't understand why I'm getting the following result:
DAYS360(A5,TODAY()) when A5 = 12/13/2006 Result = 19-Jan-00 I have also used the date format 13-Dec-06 and receive the same result. Thanks in advance, Trouvera |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
DAYS360
Oops -- the format of the result needs to be numeric.
"Trouvera52" wrote: I don't understand why I'm getting the following result: DAYS360(A5,TODAY()) when A5 = 12/13/2006 Result = 19-Jan-00 I have also used the date format 13-Dec-06 and receive the same result. Thanks in advance, Trouvera |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Days(360) function | Excel Discussion (Misc queries) | |||
| networkdays vs days360 | Excel Discussion (Misc queries) | |||
| DAYS360 function for 365 day year | Excel Worksheet Functions | |||
| Days360 problem | Excel Worksheet Functions | |||
| DAYS360 | Excel Worksheet Functions | |||
Linear Mode
