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!!

Need to ID rows in list that need to be recontacted after certain
 

Perhaps Conditional Formatting?

With
A2:A100 containg dates or blanks

Try this:
Select A2:A100, with A2 as the active cell

From the Excel main menu:
<format<conditional formatting
For Condition_1....Click the dropdown and set:
Formula is: =AND($A2<"",(TODAY()-$A2)30)
Click the [format] button and choose a pattern color (bright yellow, perhaps)
Click the [ok] buttons to finish

Now....any date that is more than 30 days old will turn the color
When you enter the new recent date....the cell reverts to the default color

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP


"The new guy" wrote:

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!!

Need to ID rows in list that need to be recontacted after certain
 

Perhaps something like:

=IF(A1+30<TODAY(),"Action Required","")

HTH

"The new guy" wrote:

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!!