| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Fill work day
I am looking to fill workday in column A, and one blank line between week.
Thanks AM |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Fill work day
Put the start date in A1, and then in A3 enter (A3 NOT A2)
=IF(A2="",A1+3,IF(WEEKDAY(A2)=6,"",A2+1)) copy A3 down and up to A2. A2 will have an #REF in it, but it affects nothing. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "AM" wrote in message ... I am looking to fill workday in column A, and one blank line between week. Thanks AM |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Fill work day
Bob, Thanks. It works fine but I have a blank line at top (only) between
monday and tue. I started out with 7/9/09 and it looks like. 07/09/2007 07/12/2007 07/13/2007 07/16/2007 07/17/2007 07/18/2007 07/19/2007 07/20/2007 Am I doing something wrong? Thanks again AM "Bob Phillips" wrote: Put the start date in A1, and then in A3 enter (A3 NOT A2) =IF(A2="",A1+3,IF(WEEKDAY(A2)=6,"",A2+1)) copy A3 down and up to A2. A2 will have an #REF in it, but it affects nothing. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "AM" wrote in message ... I am looking to fill workday in column A, and one blank line between week. Thanks AM |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Fill work day
You also need to copy A3 up to A2 as I said. You put it in A3 first, because
if you put it in A2 first, you generate a #REF error which doesn't correct in A3. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "AM" wrote in message ... Bob, Thanks. It works fine but I have a blank line at top (only) between monday and tue. I started out with 7/9/09 and it looks like. 07/09/2007 07/12/2007 07/13/2007 07/16/2007 07/17/2007 07/18/2007 07/19/2007 07/20/2007 Am I doing something wrong? Thanks again AM "Bob Phillips" wrote: Put the start date in A1, and then in A3 enter (A3 NOT A2) =IF(A2="",A1+3,IF(WEEKDAY(A2)=6,"",A2+1)) copy A3 down and up to A2. A2 will have an #REF in it, but it affects nothing. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "AM" wrote in message ... I am looking to fill workday in column A, and one blank line between week. Thanks AM |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Fill work day
That works,
Thanks AM "Bob Phillips" wrote: You also need to copy A3 up to A2 as I said. You put it in A3 first, because if you put it in A2 first, you generate a #REF error which doesn't correct in A3. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "AM" wrote in message ... Bob, Thanks. It works fine but I have a blank line at top (only) between monday and tue. I started out with 7/9/09 and it looks like. 07/09/2007 07/12/2007 07/13/2007 07/16/2007 07/17/2007 07/18/2007 07/19/2007 07/20/2007 Am I doing something wrong? Thanks again AM "Bob Phillips" wrote: Put the start date in A1, and then in A3 enter (A3 NOT A2) =IF(A2="",A1+3,IF(WEEKDAY(A2)=6,"",A2+1)) copy A3 down and up to A2. A2 will have an #REF in it, but it affects nothing. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "AM" wrote in message ... I am looking to fill workday in column A, and one blank line between week. Thanks AM |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula with DateValue and doing Fill doesn't work, need help | Excel Worksheet Functions | |||
| Cell fill colors don't appear to work... | Excel Discussion (Misc queries) | |||
| I have a list of data, fill in the gaps. FILL function won't work | Excel Discussion (Misc queries) | |||
| fill color doesn't work | Excel Worksheet Functions | |||
| Auto-fill won't work | Excel Worksheet Functions | |||
Hybrid Mode
