Date Sensitive Conditional Formula on Excel

Closed

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

Skills: Excel

See more: excel date sensitive formula, formula it, excel formula, excel ex, excel 2013, analise, excel date reminder, excel charity list, excel colour, excel 2013 formula, need formula, create address list excel, charity database, conditional database, sensitive, reminder date, charity list, excel red yellow, date reminder, charity idea, time date, excel address database, create excel database, bordeaux, create formula excel

Project ID: #4146339

Awarded to:

djain01

Hi Alex, I have read your details. Pls check the private message. Thanks djain01

$30 USD in 5 days
(12 Reviews)
4.4

8 freelancers are bidding on average $33 for this job

nagybatonyi

Please, see a working sample in PMB. Regards

$30 USD in 0 days
(39 Reviews)
5.4
DeepSyaal

Having a team of Professionals. We Provide high quality work with accuracy.

$30 USD in 1 day
(30 Reviews)
4.2
manishadk

I can provide Excel based solution. Please Check PMB For Details.

$30 USD in 1 day
(8 Reviews)
3.5
vikashgadia

yes we r ready

$30 USD in 0 days
(13 Reviews)
3.5
novaiphone

Dear. I'm interested with your project. Do you mind to choose me? I'll do it for you. I'll wait for your choosing. Regards.

$30 USD in 1 day
(3 Reviews)
1.4
sweepness

This kind of conditional formatting will be easy to implement. I can have it done quickly and accurately.

$30 USD in 1 day
(1 Review)
1.0
fsmp

Dear Sir , Right now , I have found this job post in Excel . I'm very interested in your job post involving these skills. I have had good experience in Excel . I have had online practical experience to Excel . I b More

$50 USD in 5 days
(0 Reviews)
0.0