Auto Gantt in Excel Formula/Macro

$10-30 USD

Completed

Posted

almost 9 years ago

$10-30 USD

Paid on delivery

Hi, I need a formula to show a gantt chart in excel. What this formula should do is as follows: 1. In a cell (assume C7), the formula should check the date in the header row. (Assume C1) 2. The formula should then check the date in the corresponding start coulomb (assume A7) 3. The formula should then check the date in the corresponding end coulomb (assume B7) NOW -> If the date in C1, is between A7 and B7, then cell C7 should be filled with a colour (say blue)

PHP

Software Architecture

Project ID: 8025149

About the project

2 proposals

Remote project

Active 9 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@kevivu

I am having the formula ready... If you wish I can share the formula.... Having more than 11 years of experience in banking /finance /accounting, business analysis, Data analysis, process re-engineering, copy typing, Web research, etc. Expert in MS office, which includes complex Formulae, Macros (VBA), pivot, Charts, formatting, templates, dashboard, etc. Worked on several complex excel VBA projects, viz converting Raw data to structured using vba, sales dashboard, PO tracking, budgeting, profitability, estimation, time management dashboards, etc. Also I am a quick learner and complete tasks very quickly using keyboard shortcuts and multitasking skills.

$23 USD in 1 day