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 In
5 days
Total Bids
Project Description

$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:

Current Date,

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.

Completed by:
Skills Required

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

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online