Auto Gantt in Excel Formula/Macro

$10-30 USD

已完成

已发布

将近 9 年前

$10-30 USD

货到付款

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

项目 ID: 8025149

关于此项目

2提案

远程项目

活跃9 年前

想赚点钱吗？

电子邮箱地址

在Freelancer上竞价的好处

设定您的预算和时间范围

为您的工作获得报酬

简要概述您的提案

免费注册和竞标工作

颁发给：

@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 在1天之内