vacation schedule gantt chart

Dear All,

Please help me in my school project as I need to submit it for me get to next school year.

This is a collection of all information that I found on the internet during my research on how to make schedule gantt chart style, and still i cannot bring out the output as intended on my project.

Also a module-code is included to display day/date and count days in a month and mark holidays in the calerndar gantt chart

My main concern is to make the Vacation Calendar Chart to display information according to the computation of Join Date + Vacation Frequency + Vacation Days Duration = Vacation Calendar Chart

Example:

If Mr. John Doe frequency vacation is every two months, and his joining date is 12/01/2008 the Vacation chart shows that his vacation will be from 1-Jan-2009 to 18-Jan-2009, but the next vacation which is from 19-Feb-2009 to 8-Mar-2009 is not being shown, how do i show this??? If I reference it to cell G5 and F5 the information being shown is the same as of January. HOW TO DO THIS??? I really really need help on
this one. Please help.

Please download the attached file so you see the clear picture of my problem.

An Active Gantt Chart
*=====================*

General Info
============
Date
----
All cells and/or columns containing dates should be set to "Date" format:
1) Highlight cell/cells and right-click on cell, select "Format Cells". Under "Number" tab select "Date".
OR
2) Highlight cell/cells and select "Date" in the "Number" section under the "Home" tab.

Today()
-------
Today() will return todays date.

IF()
----
IF() will evaluate a field a field in the following syntax: IF(field1,data1,data2) interpreted as IF field1 is TRUE then apply data1 ELSE data2. IF()'s can

be nested, so beware of parenthesis. The IF()'s used in this text need only be applied in order to avoid overhead.

Step 1 - Setup
==============
(0) Add the commencement date of the project to a single cell.

Step 2 - Columns
================
Set up a table with rows representing tasks and 5 columns representing the following:
(1) Task Start Date (Number Format: Date)
(2) Days from Commencement to Task Start (Number Format: General)
(3) Days from Task Start to Today (Number Format: General)
(4) Days from Today to Task End (Number Format: General)
(5) Task End Date (Number Format: Date)

A sixth column representing total days of the task can be set up for convenience. It will not be used in the Gantt chart.

Step 3 - Data
=============
The data for column 1 is: The date the task starts
The data for column 5 is: The date the task ends

Step 4 - Formulae
=================
The formula for column 2 is: =(1)-(0)
The formula for column 3 is: =IF(TODAY()<(1),(1)-(1),IF(TODAY()>(5),(5)-(1),TODAY()-(1)))
The formula for column 4 is: =IF(TODAY()<(1),(5)-(1),IF(TODAY()>(5),(5)-(5),(5)-TODAY()))
the formula for column 6 is: =(5)-(1)

Replace numbers with the repective data according to the row.

Example
=======
The above would work if the name of the cells (i.e. B4, C2, F9 etc.) were as follows:
Commencement Date: (0)
Task Start Date: (1)
Task End Date: (5)

Step 5 - The Chart
==================
Highlight columns (2), (3) and (4).
Goto the "Insert" tab and select "Other Charts" in the "Charts" section.
A drop down menu will open, select "All Chart Types..." at the bottom. Choose a "Stacked Bar Chart".

Step 6 - Gantt Setup
====================
Select the Y-axis (which in excel is the X-axis, so it's the vertical axis). Right-click on the vertical axis and select "Format Axis...".
Under the "Axis Options" tab, check the "Categorize in reverse order" checkbox.
Select the Series 1 graph data (i.e. not the graph key, but the actual bars). Make sure all the series 1 data/bars are selected, not just one bar.
Right-click and select "Fomat Data Series...".
Under the "Fill" tab, select "No Fill".
Under the "Border Color" tab, select "No Line".

Step 7 - Customization
======================
You can customize this chart to however you want it.