software

I have a workbook with five worksheets representing the days of the week
(M-F). I want to able to enter the date on the first worksheet (Monday) and
have the correct following date be automatically inserted onto each following
worksheet for that week.
--
Lee Davenport

You can use a formula

=IF(A1=quot;quot;,quot;quot;,A1 1)

where A1 holds the 1st date, the formula will add 1 to the date
if you set it up nicely you should just be able copy the formula across/down
and it will
increment by one, otherwise you can copy a cell using right click mouse and
when you release it you'll be prompted to select for instance weekdays, it's
not automatic but easy and fast
--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon

quot;Leequot; gt; wrote in message
...
gt;I have a workbook with five worksheets representing the days of the week
gt; (M-F). I want to able to enter the date on the first worksheet (Monday)
gt; and
gt; have the correct following date be automatically inserted onto each
gt; following
gt; worksheet for that week.
gt; --
gt; Lee Davenport