Re: Mon Wed Mon Wed Mon Wed Copy
- From: "T. Valko" <biffinpitt@xxxxxxxxxxx>
- Date: Mon, 11 Aug 2008 12:50:52 -0400
Most of the time Excel will automatically format cells that have date
formulas.
Glad you got it straightened out!
--
Biff
Microsoft Excel MVP
"Jim Fisher" <JimFisher@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:47B4F211-26B4-4B68-AF27-C469BAF5C56A@xxxxxxxxxxxxxxxx
BIFF
IT DOES WORK!!!
Sorry...I forgot to format as Dates!!!
-Jim
"T. Valko" wrote:
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
"Jim Fisher" <JimFisher@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:3CF1C019-0B5F-4563-AF18-6B3B5667E3C3@xxxxxxxxxxxxxxxx
It didn't work...but I get the idea....treating a date/day like a
formula
"T. Valko" wrote:
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
"Jim Fisher" <JimFisher@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:CEAEDC3D-9C16-4B24-B265-25694D5D14D1@xxxxxxxxxxxxxxxx
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.microsoft.com/office/community/en-us/default.mspx?mid=ceaedc3d-9c16-4b24-b265-25694d5d14d1&dg=microsoft.public.excel.work***.functions
.
- References:
- Mon Wed Mon Wed Mon Wed Copy
- From: Jim Fisher
- Re: Mon Wed Mon Wed Mon Wed Copy
- From: T. Valko
- Re: Mon Wed Mon Wed Mon Wed Copy
- From: Jim Fisher
- Re: Mon Wed Mon Wed Mon Wed Copy
- From: T. Valko
- Re: Mon Wed Mon Wed Mon Wed Copy
- From: Jim Fisher
- Mon Wed Mon Wed Mon Wed Copy
- Prev by Date: Table Lookup using two data elements
- Next by Date: Re: Problem Solver
- Previous by thread: Re: Mon Wed Mon Wed Mon Wed Copy
- Next by thread: Re: count if, but not if
- Index(es):
