I have excel table with "ordinal number" in first column, "debit date" in second column, "name" in third column and "date of execution" in forth column. Now I would like to have pop up reminder on file opening for every cell if 60 days have elapsed since the "date of the debit" and the "date of execution" is still empty. The pop up message should read "Its been two month since assignment of file number "Ordinal number", check the status of the file"
I have found several solutions for similar problems online but none suit me. Thank you!
Here is example file. Test file.xlsm