$30 for an Excel formula
I have an Excel charity database with a list of participants. I am visiting them on a certain frequency (ex. every 2 or 4, or 6, or 8… weeks).
I need to create a Date Sensitive Conditional Formula on Excel.
The formula has to analise:
Frequency of Visits (ex. every 2 weeks or every 4 weeks, etc.),
Date of the Last Visit
and highlight a Date Cell in Yellow as a reminder of 1 week prior to the scheduled visit,
in Red - if it is the date for the visit &
in Bordeaux colour if it is behind the scheduled visit.
In the Excel database Colum A has a date (12/01/13),
Colum B has weekly frequency (2) or (4) or (6), etc.,
Colum C - an address and so on.
The idea is to make Excel to analise the time of the last visit, refer to the current date & frequency of scheduled visits & highlight the Date Cell if it is scheduled for a next visit.
Is there any solution in Excel or I have to refer to another software to customise the database to my needs?
Hope to hear from you soon.