Date Sensitive Conditional Formula on Excel
$30-250 USD
Pago na entrega
$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.
ID do Projeto: #4146339
Sobre o projeto
Concedido a:
8 freelancers estão ofertando em média $33 nesse trabalho
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.
This kind of conditional formatting will be easy to implement. I can have it done quickly and accurately.