Hello,

I need assistance in adjusting a formula that is currently being used to determine the difference between two dates.

=IF(I2<>"",(DAYS(I2,H2)),"")

The columns being used are H-J. H is a deadline date. I is the date the information was received. J is the difference between the two dates and where the formula is located. For example, a deadline was requested for June 20th (H) and the requested information was received on June 23rd (I), so J returns the number 3.

My problem is that on occasion we do not have a deadline (for various reasons) and receive information after the fact. In those instances, we are still entering the date the information was received in column I, but column H is left blank (since no deadline had been requested). This results in a long number being returned in column J (ex. H is blank, I is June 21st, J returns 42907).

I need the formula to ignore the blank cell, or rather, return either a blank cell or a zero value in column J if H is blank. I've tried messing with the formula and can't seem to get it to work. Help!