I currently am trying to create a formula in which I calculate days since last contact, with some of the source cells either being blank or having "N/A" as a value. I plan to make cells either all blank or "N/A" if the person hasnt been contacted.
what I am trying to do is have a tonow(date of last contact) formula in which if the cell is blank or N/A it states "N/A" instead of "invalid date".
The solution here could be adding an IF() statement at the beginning of your date difference tracking formula. The IF() condition should check whether the last contact date is empty and if it is put the value that you would like to show in that case (this could be N/A or even something else like "NEVER CONTACTED). If not empty, the IF() condition should show the date difference