View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Roberta H via OfficeKB.com
 
Posts: n/a
Default proper syntax order

Thank you so very much Steve!
Yes it works great! One problem I had, however, was getting an accurate
count from the very date received to the "date", so I made a very small
modification to the formula:
=IF(ISBLANK(H191),0,DATEDIF(G191-1,H191,"d")).

**************************************

SteveG wrote:
Roberta,

Assuming A1= "Date", B1 = "Received Date" & C1 = "Total Days" then in
C2 enter:

=IF(ISBLANK(A2),0,DATEDIF(B2,A2,"d"))

HTH

Steve


--
Message posted via http://www.officekb.com