Fill work day

[Guest]

I am looking to fill workday in column A, and one blank line between week.

Thanks
AM

 

[Bob Phillips]

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)

 

[Guest]

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]

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)

 

[Guest]

That works,

Thanks
AM

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)