I am in the process of creating a gantt chart in Excel 2007 for various
projects my company performing. I have created formulas so that the current
date used to calculate the number of days remaining and the number of days
past. I was wondering if there was anyway to link the current date to the
control panel so it automatically updates everyday? This way I do not have to
manually do it.

Thanks to everyone that helps