copy down

[robzrob]

B4:B9 is 04/08/08
B10:B15 is 05/08/08
B16:B21 is 06/08/08
B22:B27 is 07/08/08
B28:B33 is 08/08/08

ie Mon-Fri dates, then

B38:B43 needs to be 11/08/08
B44:B49 needs to be 12/08/08
B50:B55 needs to be 13/08/08
B56:B61 needs to be 14/08/08
B62:BB67 needs to be 15/08/08

and so on. What can I put in B4:B9, etc to make the weekday dates
appear in the right places when I select and copy down B1:B34?

 

[FSt1]

hi
i take it you have 6 line of one date each, repeating every 6 lines using
format
dd/mm/yy. if my observation is correct then i wouldn't try to copy all that
down. instead i would use a formula.
in b38, i would enter =b4+7, copy the formula down. then copy the formulas
and paste as values.

post back if i misunderstood
regards
FSt1

 

[Glenn]

B4:B9 is 04/08/08
B10:B15 is 05/08/08
B16:B21 is 06/08/08
B22:B27 is 07/08/08
B28:B33 is 08/08/08

ie Mon-Fri dates, then

B38:B43 needs to be 11/08/08
B44:B49 needs to be 12/08/08
B50:B55 needs to be 13/08/08
B56:B61 needs to be 14/08/08
B62:BB67 needs to be 15/08/08

and so on. What can I put in B4:B9, etc to make the weekday dates
appear in the right places when I select and copy down B1:B34?

With start date in A1, put this in B4 and fill down as far as needed:

=IF((INT((MOD((ROW()-4),34))/6))<5,$A$1+(INT((ROW()-4)/34))*7+(INT((MOD((ROW()-4),34))/6)),"")

 

[Teethless mama]

Enter date in B4
B5: =$B$4+INT((ROWS($1:2)-1)/6)

copy down from B5 as far as needed

 

[robzrob]

Enter date in B4
B5: =$B$4+INT((ROWS($1:2)-1)/6)

copy down from B5 as far as needed








- Show quoted text -

Thanks all. G - yours worked, F & T - Sorry, yours didn't. Perhaps
something to do with my having cells with things in them other than
dates between the date -cells?