Making Excel build a Gant Chart

  • Thread starter Thread starter John T.
  • Start date Start date
J

John T.

Currently I have a database query that pulls workorder numbers and their
corresponding start dates and completion dates from an Access database, and
places them in three columns in Excel. I'm trying to create a calendar that
will use these dates to show me when the workorder started and when it
finished and all the dates in between. This is what I have right now.

=IF(AND(B2>calender!B5,C2>calender!B5),"X",(IF(AND(B2<calender!B5,C2<calende
r!B5),"",(IF(AND(B2>calender!B5,C2<calender!B5),"A",(IF(AND(B2<calender!B5,C
2>=calender!B5),"X",""))))))) {bouncing the dates off of another worksheet
titled calender}

My biggest problem is the start and completion fields in Access are
configured as DD/MM/YYYY 00:00:00 ??. This keeps me from being able to use
the equals sign in any calculations unless I create the calendar page using
every second of every day. Can anybody give me any ideas. If I can get this
to work, it will create a self generating Gant Chart.

John T.
 
You might want to try the DATE function... not sure if it's the best
solution, but it'll probably help.

So if C2 is your date in yyyy/mm/dd HH:mm format, you can get it out of that
by doing
= date(year(c2), month(c2), day(c2))

Beverley
 
Back
Top