Good morning,

I wanted to create a small Gantt chart via Excel using conditional
formatting with weeks instead of days. Everything seems to be working fine
except when a project starts and finishes within the same week. It doesn't
show anything.

What would be the proper way to have a a cell refering to the beginning of
the week so that it is being shown in my chart??

Thank you very much for your help.