Fill Mon-Wed-Fri dates?

THANK YOU! This was VERY clever - I use Excel on a regular basis, however, I
learned something new today - I did not know that a function {such as OR in
this case} could be used as you have done - VERY cool! And this works like a
charm - whew! Much appreciated - Thanks again!

"John C" wrote:

> down and dirty
> A2: 8/4/08 (or some other day that is definitely Mon, Wed, or Fri)
> A3: =A2+2*OR(WEEKDAY(A2)=2,WEEKDAY(A2)=4)+3*(WEEKDAY(A2)=6)
> Copy A3 down as needed.
>
> or, for Tue / Thu
> A2: 8/5/08 (or some other day that is definitely Tue or Thu)
> A3: =D2+2*(WEEKDAY(D2)=3)+5*(WEEKDAY(D2)=5)
>
> Hope this helps.
> --
> John C
>
>
> "LynneCreek" wrote:
>
> > I'm a college instructor and would REALLY like to find a way to automatically
> > fill the dates for MWF classes or for T-Th classes. So far all I can get
> > excel to do is either weekdays or every-other day. Any suggestions would be
> > helpful!

Try these...

Enter the first date in a cell. This date must be a weekday in the sequence.

For M-W-F

A1 = 8/6/2008 (which is a Wednesday)

Enter this formula in A2 and copy down as needed:

=A1+LOOKUP(WEEKDAY(A1),{0,2,6},{2,2,3})

For T-Th

A1 = 8/7/2008 (which is a Thursday):

Enter this formula in A2 and copy down as needed:

=A1+LOOKUP(WEEKDAY(A1),{0,5},{2,5})


--
Biff
Microsoft Excel MVP


"LynneCreek" <LynneCreek.TakeThisOut@discussions.microsoft.com> wrote in message
news:34E11BC6-1544-4B79-A83D-1E0C0EED1A1B@microsoft.com...
> I'm a college instructor and would REALLY like to find a way to
> automatically
> fill the dates for MWF classes or for T-Th classes. So far all I can get
> excel to do is either weekdays or every-other day. Any suggestions would
> be
> helpful!

THANK YOU! Another very clever fix - I definitely did not think about using
a Lookup function this way - I've learned something ELSE new today! Wahoo!
This also works just GREAT!

Again - my sincere thanks


"T. Valko" wrote:

> Try these...
>
> Enter the first date in a cell. This date must be a weekday in the sequence.
>
> For M-W-F
>
> A1 = 8/6/2008 (which is a Wednesday)
>
> Enter this formula in A2 and copy down as needed:
>
> =A1+LOOKUP(WEEKDAY(A1),{0,2,6},{2,2,3})
>
> For T-Th
>
> A1 = 8/7/2008 (which is a Thursday):
>
> Enter this formula in A2 and copy down as needed:
>
> =A1+LOOKUP(WEEKDAY(A1),{0,5},{2,5})
>
>
> --
> Biff
> Microsoft Excel MVP
>
>
> "LynneCreek" <LynneCreek RemoveThis @discussions.microsoft.com> wrote in message
> news:34E11BC6-1544-4B79-A83D-1E0C0EED1A1B@microsoft.com...
> > I'm a college instructor and would REALLY like to find a way to
> > automatically
> > fill the dates for MWF classes or for T-Th classes. So far all I can get
> > excel to do is either weekdays or every-other day. Any suggestions would
> > be
> > helpful!
>
>
>

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"LynneCreek" <LynneCreek RemoveThis @discussions.microsoft.com> wrote in message
news:BD53D9B4-6982-4D59-A5D5-0A234198F2DC@microsoft.com...
> THANK YOU! Another very clever fix - I definitely did not think about
> using
> a Lookup function this way - I've learned something ELSE new today!
> Wahoo!
> This also works just GREAT!
>
> Again - my sincere thanks
>
>
> "T. Valko" wrote:
>
>> Try these...
>>
>> Enter the first date in a cell. This date must be a weekday in the
>> sequence.
>>
>> For M-W-F
>>
>> A1 = 8/6/2008 (which is a Wednesday)
>>
>> Enter this formula in A2 and copy down as needed:
>>
>> =A1+LOOKUP(WEEKDAY(A1),{0,2,6},{2,2,3})
>>
>> For T-Th
>>
>> A1 = 8/7/2008 (which is a Thursday):
>>
>> Enter this formula in A2 and copy down as needed:
>>
>> =A1+LOOKUP(WEEKDAY(A1),{0,5},{2,5})
>>
>>
>> --
>> Biff
>> Microsoft Excel MVP
>>
>>
>> "LynneCreek" <LynneCreek RemoveThis @discussions.microsoft.com> wrote in message
>> news:34E11BC6-1544-4B79-A83D-1E0C0EED1A1B@microsoft.com...
>> > I'm a college instructor and would REALLY like to find a way to
>> > automatically
>> > fill the dates for MWF classes or for T-Th classes. So far all I can
>> > get
>> > excel to do is either weekdays or every-other day. Any suggestions
>> > would
>> > be
>> > helpful!
>>
>>
>>

SGkuICBKdXN0IGFub3RoZXIgb3B0aW9uLg0KDQpJZiBBMSBoYXMgYSBNLFcsIG9yIEYgZGF0ZSwg
dGhlbiBwZXJoYXBzLi4uDQo9QTErTU9EKDE3LFdFRUtEQVkoQTEpKzEpDQoNCklmIEExIGhhcyBh
IFR1ZXMsIG9yIFRodXIgZGF0ZS4uLg0KPUExK01PRCgxMixXRUVLREFZKEExKSsyKQ0KDQotLSAN
CkhUSCAgOj4pDQpEYW5hIERlTG91aXMNCg0KDQoiTHlubmVDcmVlayIgPEx5bm5lQ3JlZWtAZGlz
Y3Vzc2lvbnMubWljcm9zb2Z0LmNvbT4gd3JvdGUgaW4gbWVzc2FnZSBuZXdzOjM0RTExQkM2LTE1
NDQtNEI3OS1BODNELTFFMEMwRUVEMUExQkBtaWNyb3NvZnQuY29tLi4uDQo+IEknbSBhIGNvbGxl
Z2UgaW5zdHJ1Y3RvciBhbmQgd291bGQgUkVBTExZIGxpa2UgdG8gZmluZCBhIHdheSB0byBhdXRv
bWF0aWNhbGx5IA0KPiBmaWxsIHRoZSBkYXRlcyBmb3IgTVdGIGNsYXNzZXMgb3IgZm9yIFQtVGgg
Y2xhc3Nlcy4gIFNvIGZhciBhbGwgSSBjYW4gZ2V0IA0KPiBleGNlbCB0byBkbyBpcyBlaXRoZXIg
d2Vla2RheXMgb3IgZXZlcnktb3RoZXIgZGF5LiAgQW55IHN1Z2dlc3Rpb25zIHdvdWxkIGJlIA0K
PiBoZWxwZnVsIQ==