View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
aussiegirlone aussiegirlone is offline
external usenet poster
 
Posts: 94
Default 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