Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Bug in days360 function
Hi,
If you enter days360(A1,A2) where A1 is April, 18, 2006 and A2 is March, 31, 2007 you get correctly 343 days. BUT if you enter it the opposite way, i.e. days360(A2,A1), you get -342 days. My HP calculator disagrees with this, and gives logicaly 343 and -343. Any explanation? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating a Custom Excel Function to Calculate Gini Coefficients | Excel Worksheet Functions | |||
Date & Time | New Users to Excel | |||
Hyperlinks using R[1]C[1] and offset function in its cell referenc | Excel Worksheet Functions | |||
Conversion | Excel Worksheet Functions | |||
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions |