Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Worksheet Functions / May 2008

Tip: Looking for answers? Try searching our database.

Calculate Follow-Up Dates - Please help ASAP

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
jewelzeyes - 31 May 2008 00:12 GMT
I am trying to create a database of potential volunteers, including each date
we have made contact with them. There are a lot that have not replied to
emails for whatever reason so I want to follow-up with them. I just need to
know when to contact them again. There's got to be a way to use excel to
calculate the next date each person needs to be contacted again. For example,
2 weeks from their last contact date, so then I can just sort by date, and
see who should be e-mailed each day. I know it can be done but anything I
find wants me to pay for it.

I'm not sure if this is the best way to set this up or not but I want this
info in my database. So far I just have these columns (so I can sort each)

NEXT CONTACT, Initial, 2nd, 3rd, 4th, Last Name, First Name, Position,
Address, Phone, Email

What is the best way to set this up and what formulas should I use?
Bernie Deitrick - 31 May 2008 01:22 GMT
Use a formula:

=CellWithInitialContactDate + 14

like

=A2 + 14

Format the cell for date.

In Excel, dates are simply the count of days since the start of the 20th
century, so each day is simply one more than the previous.
Times are decimal values, from 0 to 1, for 1 to 24 hours.

You could also use a conditional for when you have contacted them:

=IF(Cellwithcontactcompletion = "Contacted", "", A2 + 14)

HTH,
Bernie
MS Excel MVP

>I am trying to create a database of potential volunteers, including each
>date
[quoted text clipped - 15 lines]
>
> What is the best way to set this up and what formulas should I use?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.