| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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!! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sorting rows into a list | Excel Discussion (Misc queries) | |||
| how do I insert 4 rows in between each value in a list of data | Excel Discussion (Misc queries) | |||
| how to add rows to a list that is within one cell | New Users to Excel | |||
| quicker entry of list rows | Excel Discussion (Misc queries) | |||
| Conditional list without blank rows | Excel Worksheet Functions | |||
Threaded Mode
