How do I set up a project calender?
 

I am trying to set up a spreadsheet that you can enter a task its start date
and target date and it would calculate the # of days and project a bar across
the calender on the right.

How do I set up a project calender?
 

In principle you can do this but you would need to be careful if using
your dates to define the length of a rectangle superimposed on the
spreadsheet. This is because graphics are very easily moved and can
have problems sorting.

You may be better to use a purpose built application such as MS
project.


--
mrice

Research Scientist with many years of spreadsheet development experience
------------------------------------------------------------------------
mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931
View this thread: http://www.excelforum.com/showthread...hreadid=544802