Vaya,

There was one little thing missing:

=IF(AND(MONTH(C$1)=MONTH($A$2),C$1<$B$2),"1","")

Many Thanks,

SamuelT


--
SamuelT
------------------------------------------------------------------------
SamuelT's Profile:
http://www.excelforum.com/member.php...o&userid=27501
View this thread: http://www.excelforum.com/showthread...hreadid=544666

"ExcelQuery" wrote in message
...
I need to create a Gantt chart using Excel 2003. I found an article on
this
site for doing this in Excel 2003, but it doesn't quite do the same thing
in
the 2003 version.

Could anyone help with this?