I have an IF statement in cell E4 that will populate text for true or false based on a date in cell D3. The statement is looking to see if the date is older than 30 days, if so, enter text "Follow up to letter 1", if false, "No follow up needed for Letter 1". I'd like to have cell E4 display the False condition is there is NO date in D4. How can I accomplish this? Please see my attachment.
Bookmarks