A
aussiegirlone
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(Q2>0,Q1>0),DAYS360(Q2,Q1),""),"")
Tuesday, 1 July 2008
Monday, 24 November 2008
(143)
=DATEDIF(L2,TODAY(),"d")
Tuesday, 1 July 2008
146
fix the discrepancy of three days
=IF(Q2>=Q1,IF(AND(Q2>0,Q1>0),DAYS360(Q2,Q1),""),"")
Tuesday, 1 July 2008
Monday, 24 November 2008
(143)
=DATEDIF(L2,TODAY(),"d")
Tuesday, 1 July 2008
146