Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Finding latest transaction and seeing if it is over a year old.
I have a database for a carpet cleaning business.I want to be able to send
out reminders if has been over a year since I last cleaned a person's carpet. But I DON'T want to send out a "year notice" a month after I just sent one out(A year and a month out). Each row has: Date of service, First name, last name, address, date of mailing. I want to be able to have another column that will alert me if the latest date of mailing is over a year old. Then I will know it is time to mail a reminder again. Obviously if I service a person's carpet six months after I last mailed them a notice I want the alert column to "change" to alert me when it has been a year since I last serviced their carpet NOT since I last mailed them a notice which was earlier. I hope this is making sense. Thanks for any help. Jim |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Has anybody figured this out yet?
A B C D E
DOS FN LN ADD DOM 1 2 3 Assuming the above to be the format you are using.... I would use column F and this equation. in F3 put: =IF(AND(NOW()-E2365,NOW()-A2365),"MAIL","Don't Mail") If I interpretted your question correctly, this should do it. This will make sure that it has been at least a year since the carpet was serviced and at least a year since the last mailer was sent. Random On Wed, 27 Aug 2003 06:13:54 -0500, "Jim" wrote: Has anybody figured this out yet? "Jim" wrote in message ... I have a database for a carpet cleaning business.I want to be able to send out reminders if has been over a year since I last cleaned a person's carpet. But I DON'T want to send out a "year notice" a month after I just sent one out(A year and a month out). Each row has: Date of service, First name, last name, address, date of mailing. I want to be able to have another column that will alert me if the latest date of mailing is over a year old. Then I will know it is time to mail a reminder again. Obviously if I service a person's carpet six months after I last mailed them a notice I want the alert column to "change" to alert me when it has been a year since I last serviced their carpet NOT since I last mailed them a notice which was earlier. I hope this is making sense. Thanks for any help. Jim |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Latest date for each of the year | Excel Discussion (Misc queries) | |||
Help with pulling data based on latest date for a year | Excel Discussion (Misc queries) | |||
Formula to Find Latest Transaction Date and amount for a customer | Excel Discussion (Misc queries) | |||
Finding Latest Variable | Excel Discussion (Misc queries) | |||
Transaction type/ Transaction amount in two separate columns | New Users to Excel |