software

Why can't Excel Auto format for Tuesdays and Thursdays or Monday and
Wednesdays. 2 cells make up a week. The 2 cells refer to Tue and Thur. I
want to highlight the 2 cells with the proper date...then drag---auto
format---the remanding cell. For Example A1 and B1 are Tu and Th
respectivly, with 2/14/06 and 2/16/06 in cells A2 and B2. The next two
cells...C1 and D1 are again Tu and Th...and I want C2 and D2 to be 2/21/06
and 2/23/06...and continue that formating for the next 16 weeks. Excel can
not figure out I'm only looking at Tu and Th only.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the quot;I
Agreequot; button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click quot;I Agreequot; in the message pane.

www.microsoft.com/office/comm...lic.excel.misc

Try this:

Insert your 2 dates in A1 and B1, in C1 type =A1 7, in D1 type =B1 7, select
C11 and drag across as far as needed.

HTH
JG

quot;Jim Fisherquot; wrote:

gt; Why can't Excel Auto format for Tuesdays and Thursdays or Monday and
gt; Wednesdays. 2 cells make up a week. The 2 cells refer to Tue and Thur. I
gt; want to highlight the 2 cells with the proper date...then drag---auto
gt; format---the remanding cell. For Example A1 and B1 are Tu and Th
gt; respectivly, with 2/14/06 and 2/16/06 in cells A2 and B2. The next two
gt; cells...C1 and D1 are again Tu and Th...and I want C2 and D2 to be 2/21/06
gt; and 2/23/06...and continue that formating for the next 16 weeks. Excel can
gt; not figure out I'm only looking at Tu and Th only.
gt;
gt; ----------------
gt; This post is a suggestion for Microsoft, and Microsoft responds to the
gt; suggestions with the most votes. To vote for this suggestion, click the quot;I
gt; Agreequot; button in the message pane. If you do not see the button, follow this
gt; link to open the suggestion in the Microsoft Web-based Newsreader and then
gt; click quot;I Agreequot; in the message pane.
gt;
gt; www.microsoft.com/office/comm...lic.excel.misc