Date Sensitive Conditional Formula on Excel
This project was successfully completed by djain01 for $30 USD in 5 days.Get free quotes for a project like this
Project Budget$30 - $250 USD
Completed In5 days
$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.
Looking to make some money?
- Set your budget and the timeframe
- Outline your proposal
- Get paid for your work
Hire Freelancers who also bid on this project
Looking for work?
Work on projects like this and make money from home!Sign Up Now
- The New York Times
- Wall Street Journal
- Times Online