Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Fill Mon-Wed-Fri dates?
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! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Fill Mon-Wed-Fri dates?
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(A 2)=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! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Fill Mon-Wed-Fri dates?
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" wrote in message ... 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! |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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(A 2)=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! |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Fill Mon-Wed-Fri dates?
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" wrote in message ... 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! |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Fill Mon-Wed-Fri dates?
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "LynneCreek" wrote in message ... 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" wrote in message ... 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! |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Fill Mon-Wed-Fri dates?
Hi. Just another option.
If A1 has a M,W, or F date, then perhaps... =A1+MOD(17,WEEKDAY(A1)+1) If A1 has a Tues, or Thur date... =A1+MOD(12,WEEKDAY(A1)+2) -- HTH :) Dana DeLouis "LynneCreek" wrote in message ... 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dragging to fill dates | Excel Discussion (Misc queries) | |||
fill in dates | Excel Discussion (Misc queries) | |||
Auto fill dates | Excel Worksheet Functions | |||
auto fill row with dates | Excel Discussion (Misc queries) | |||
CUSTOM FILL USING DATES | New Users to Excel |