Formula Help! IF

997 3
Showing results for 
Search instead for 
Did you mean: 
6 - Interface Innovator
6 - Interface Innovator


I am trying to do something and need some help! We are tracking the submitted date of an invoice and the day it was settled. The difference is what we are looking at. The problem is I know how to figure that out, but I am struggling with how to add in the condition that says IF the “Settled Date” is blank, leave the “Days to Settle” blank. That way, if we don;t it settled yet (i.e. there is no date entered into that cell) it won’t have an #ERROR! on every line of the sheet.

Is there anyway to do this? Thanks in advance.

3 Replies 3

This should do it:

   {Settled Date},
   << your date formula here >>

Beat me to it :slightly_smiling_face: IF(Date2,DATETIME_DIFF(Date2,Date1,‘days’))

Thanks - I will give this a try!