Note: Same scenario from my original request the columns are E and G instead of I and M as well as different contact information
Column A is where the formula is entered, column E is the Issued Date (open) and Column G is the Returned Date (closed)
Formula
=IF((TODAY()-E2)>366,"Contact Issued To or Department","")
Works great if the date is greater >366 in column E then the message pops up in column A. What I need is if column G has a returned date for column A to stay blank.
If date in E is greater than 366 enter message, but if column G is not blank no message.
I am not sure if my file uploaded, but below is an example of what I am talking about. Thanks!!!
A B C D E F G
| Contact Issued To/Department in Comments column if message is seen | LOGBOOK # | LOGBOOK TITLE | ISSUED TO | Issued Date | DEPARTMENT/ LOCATION | Date Returned for Archiving |
| Contact Issued To or Department | 12/22/15 | 12/22/16 |
Give this a try
=IF(AND(E2<>"",(TODAY()-E2)>366,G2=""),"Contact Issued To or Department","")
Sunny
Hi Sunny,
Thank you that does work, now my problem Once I put the formula in A1 I need A1 to stay blank if E2 is less than 366, another words column A1 needs to be blank unless E is greater than 366 and G2 is blank
Thanks,
Diane
Hi Diane
My formula will also work for that scenario. See the part in red.
=IF(AND(E2<>"",(TODAY()-E2)>366,G2=""),"Contact Issued To or Department","")
Sunny
