Can Anyone Help

[JamieCuk1]

Hi new here need some help with a excel formula. Im sure some one mus
no the answer. The problem is as follows:

I have a spread sheet for staff showing start durations in one cell an
completion date in another cell. example:

in Cell A9 is "planner" the start date in cell b9 is 6/jan/04 an
completion date in cell c9 is 3/dec/07.

Across the top of the spread sheet i then have in each cell jan, feb
ect until dec 2007. example:

cell e8 is j (for Jan) f8 is f (for feb)

I am trying to create a formula that will atomatically fill in (colour
the cells across the planners row for each cell month he is working i.
Jan to Dec cells filled in block colour yellow for example

cheers hope this not to complecated

 

[Frank Kabel]

Hi
have a look at the following example:
http://j-walk.com/ss/excel/files/timeline.exe

In addition you may search the Google archive for 'Gant chart'

HTH
Frank

Hi new here need some help with a excel formula. Im sure some one must
no the answer. The problem is as follows:

I have a spread sheet for staff showing start durations in one cell
and completion date in another cell. example:

in Cell A9 is "planner" the start date in cell b9 is 6/jan/04 and
completion date in cell c9 is 3/dec/07.

Across the top of the spread sheet i then have in each cell jan, feb,
ect until dec 2007. example:

cell e8 is j (for Jan) f8 is f (for feb)

I am trying to create a formula that will atomatically fill in
(colour) the cells across the planners row for each cell month he is
working i.e Jan to Dec cells filled in block colour yellow for

example