Mon Wed Mon Wed Mon Wed Copy

Mon Wed Mon Wed Mon Wed Copy

Post by SmltIEZpc2 » Tue, 12 Aug 2008 07:27:01


I have days that repeat Mon Wed Mon Wed, etc... on a schedule. Next to those
days are dates like 8/25/08 and 8/27/08.

It would be NICE if I could highlight those two dates, than using my mouse
move to the lower right hand corner of that highlighted box, so that the "+"
plus sign appears. Than drag that box down so I get new dates like 9/01/08
and 9/03/08 etc for a few months.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" 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 "I Agree" in the message pane.

http://www.yqcomputer.com/
 
 
 

Mon Wed Mon Wed Mon Wed Copy

Post by T. Valk » Tue, 12 Aug 2008 07:52:22

Try this:

Enter the first date in a cell, say, A1. The first date must be either a
Monday or Wednesday date.

A1 = 8/11/2008 (Monday)

Enter this formula in A2 and copy down as needed:

=A1+IF(WEEKDAY(A1)=2,2,5)

--
Biff
Microsoft Excel MVP

 
 
 

Mon Wed Mon Wed Mon Wed Copy

Post by SmltIEZpc2 » Tue, 12 Aug 2008 08:46:00


It didn't work...but I get the idea....treating a date/day like a formula
 
 
 

Mon Wed Mon Wed Mon Wed Copy

Post by T. Valk » Tue, 12 Aug 2008 10:38:35

>It didn't work...

Care to expand on that?

I can assure you it does work if you followed my suggestion.

--
Biff
Microsoft Excel MVP
 
 
 

Mon Wed Mon Wed Mon Wed Copy

Post by SmltIEZpc2 » Tue, 12 Aug 2008 22:14:00

Hi Biff,

Here is what I did---2 different methods and results:

Method 1: In A1 I put

8/11/2008 (Monday)

in B1 I put

=A1+IF(WEEKDAY(A1)=2,2,5)

my results are (being copied a few cells down)

#Value!
#Value!
#Value!
#Value!
#Value!

Method 2: In A1 I put

8/11/2008

in B1 I put

=A1+IF(WEEKDAY(A1)=2,2,5)

my results are (being copied a few cells down)

39673
39678
39680
39685
39687
39692
39694
39699
39701
39706

I was hoping instead to have Dates that appeared as Mon Wed Mon Wed....

or

8/11/2008
8/13/2008
8/25/2008
8/27/2008
9/1/2008
9/3/2008
etc....

-Jim
 
 
 

Mon Wed Mon Wed Mon Wed Copy

Post by SmltIEZpc2 » Tue, 12 Aug 2008 22:15:01


BIFF

IT DOES WORK!!!

Sorry...I forgot to format as Dates!!!


-Jim
 
 
 

Mon Wed Mon Wed Mon Wed Copy

Post by T. Valk » Wed, 13 Aug 2008 01:50:52

Most of the time Excel will automatically format cells that have date
formulas.

Glad you got it straightened out!

--
Biff
Microsoft Excel MVP