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
Bookmarks