Making Excel build a Gant Chart

[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.

 

[Beverley]

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