|
Fill work day
I am looking to fill workday in column A, and one blank line between week.
Thanks AM |
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 |
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 |
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 |
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 |
| All times are GMT +1. The time now is 05:34 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com