| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Mon Wed Mon Wed Mon Wed Copy
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/comm...et.f unctions |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Mon Wed Mon Wed Mon Wed Copy
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" wrote in message ... 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/comm...et.f unctions |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Mon Wed Mon Wed Mon Wed Copy
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" wrote in message ... 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/comm...et.f unctions |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Mon Wed Mon Wed Mon Wed Copy
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" wrote in message ... 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" wrote in message ... 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/comm...et.f unctions |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Mon Wed Mon Wed Mon Wed Copy
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 "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" wrote in message ... 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" wrote in message ... 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/comm...et.f unctions |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Mon Wed Mon Wed Mon Wed Copy
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" wrote in message ... 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" wrote in message ... 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/comm...et.f unctions |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Mon Wed Mon Wed Mon Wed Copy
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" wrote in message ... 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" wrote in message ... 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" wrote in message ... 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/comm...et.f unctions |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy and paste versus copy and insert copied cells | New Users to Excel | |||
| I copy a formula and the results copy from the original cell | Excel Discussion (Misc queries) | |||
| copy between worksheets does not copy formulae just values | Excel Discussion (Misc queries) | |||
| Copy/Paste how to avoid the copy of formula cells w/o calc values | Excel Discussion (Misc queries) | |||
| EXCEL FILE a copy/a copy/a copy ....filename | New Users to Excel | |||
Linear Mode
