I work in a doctor’s office in a hospital, and the Chief Physiotherapist
asked me to redo their yearly schedules. I based myself on their
previous schedule, but added color and style to it. We use at the
hospital the software Excel 2000. So, in cell B1, from the Menu, I
clicked: Format, Cells, Number, Date, and in Type, I chose the format
**Wednesday, March 14, 2001*. I had to repeat the same process to cell
B9, B17, B25, up to B97, changing the date accordingly in each cell.
The Physiotherapist was impressed by my work, but had a concern
regarding the individual dating of the cells.

He asked me to find a formula (I say: a Script) that would be written
in one cell and would perform the task itself. Although I am an
Intermediate Level user, I cannot find such formula. Better, I don’t
know how to create one.

So, I am asking the Excel 2000 wizards for their help: Is it possible
to find a formula or a script that would perform this task, with the
daily increment, and how would it be done?

I thank you in advance for your help. It will be much appreciated.

Magnumcdi


--
magnumcdi
------------------------------------------------------------------------
magnumcdi's Profile: http://www.excelforum.com/member.php...o&userid=28772
View this thread: http://www.excelforum.com/showthread...hreadid=484607