My formula result shows in blank cells

[chrisellis250]

Hello,

I currently have a table to keep on top of due dates for letters etc. In column I I have a number of dates, which are all inputted by the user.

Column R just calculates the number of days between that date and today.

I then have a Formula in Column Q:

=IF(R2>7,"Letter to be drafted","")

This is copied down 200 rows so that this function is automated when dates are entered. However, where there is no date in Column I the values in Column Q all show "Letter to be drafted" but I want this to be blank.

How can I get that formula to ignore it if I2 is blank?

Many thanks

[AliGW]

How about this?

=IF(I2="","",R2>7,"Letter to be drafted",""))

[Syrkrasi]

Try This
=IF(ISBLANK(I2),"",IF(R2>7,"Letter to be drafted",""))

[davsth]

=IF(and(I2<>"",R2>7),"Letter to be drafted","")