View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
The new guy[_2_] The new guy[_2_] is offline
external usenet poster
 
Posts: 4
Default Need to ID rows in list that need to be recontacted after certain

I have a contact list that is getting longer by the day and I'm falling
behind on follow up.

Every time I contact someone on the list, I update the date & time in a
specific column (let's say A). What I need is a formula that changes a
variable in a new column when I have not updated information in column A in a
long time (ie. 30 days). That way I can easily organize and prioritize my list

I have tried playing around with the IF function but can't seem to get the
date/time component to work for me. Any help would be GREATLY appreciated!!