Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formular discrepencies
Can anyone tell me why these two formulas give two different results? Can you
fix the discrepancy of three days =IF(Q2=Q1,IF(AND(Q20,Q10),DAYS360(Q2,Q1),""),"" ) Tuesday, 1 July 2008 Monday, 24 November 2008 (143) =DATEDIF(L2,TODAY(),"d") Tuesday, 1 July 2008 146 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formular | New Users to Excel | |||
I still need help with formular? | Excel Worksheet Functions | |||
formular | Setting up and Configuration of Excel | |||
If formular | Excel Discussion (Misc queries) | |||
Need Help With A Formular | New Users to Excel |