Combining Two Formulas in 1 cell

[CareerServices]

Is there way to combine this IF formula: =IF(OR(ISBLANK(I2),ISBLANK(A2)), "",) with this DAYS formula: =DAYS(I2,A2) into 1 cell.

What i am trying to accomplish is calculate the number of days left for a certain date but if the date (cell I2) is not entered yet I want the count down cell to remain empty

 

[Joe4]

Try this:

=IF(AND(A2>0,I2>0),[COLOR=#333333]DAYS(I2,A2),"")
[/COLOR]

 

[jtakw]

Hi,

You're missing the "Value if False" in your IF formula, so just insert your DAYS formula there:

=IF(OR(ISBLANK(I2),ISBLANK(A2)),"",DAYS(I2,A2))

 

[jtakw]

Thanks for the feedback, you're welcome, welcome to the forum.