ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   URGENT: Control Different Start Dates (https://www.excelbanter.com/excel-discussion-misc-queries/139314-urgent-control-different-start-dates.html)

Marco

URGENT: Control Different Start Dates
 
Hi. I have a list of employees and different Start Dates of their contracts.
Well, in Column A I have the name and the next two (B and C) I have the Start
and End date. For the folling columns I also have ohter Start and End dates.
Imagine this:

Name Start End Start End Start End Start End Start End

I need to build a map like a Gant chart. I need paint cells that contains
data from those dates.

Any idea?

Regards in advance.
Marco

Barb Reinhardt

URGENT: Control Different Start Dates
 
Jon Peltier has put together instructions on a Gantt Chart.

http://www.peltiertech.com/Excel/Cha...dex.html#Gantt

That should help you.

"Marco" wrote:

Hi. I have a list of employees and different Start Dates of their contracts.
Well, in Column A I have the name and the next two (B and C) I have the Start
and End date. For the folling columns I also have ohter Start and End dates.
Imagine this:

Name Start End Start End Start End Start End Start End

I need to build a map like a Gant chart. I need paint cells that contains
data from those dates.

Any idea?

Regards in advance.
Marco



All times are GMT +1. The time now is 02:46 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com