Replicating

Hi All,

Is there a way to replicate cells for a weekly basis. If I enter the
17/07/06 in one cell, can I replicate it in the next cell to show 24/07/06
and so on.

Office 2003.

Thanks,
kfh.

k f h wrote:
> Hi All,
>
> Is there a way to replicate cells for a weekly basis. If I enter the
> 17/07/06 in one cell, can I replicate it in the next cell to show
> 24/07/06 and so on.
>
> Office 2003.
>
> Thanks,
> kfh.

Hi kfh,

suppose you have 17/07/06 in A1 and want 24/07/06 in B1. Just input in B1the
formula:

=A1+7


--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy

put 17/07 in one cell, 24/07 in the next cell, select them both, and
drag-copy

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"k f h" <[email protected]> wrote in message
news:[email protected]...
>
> Hi All,
>
> Is there a way to replicate cells for a weekly basis. If I enter the
> 17/07/06 in one cell, can I replicate it in the next cell to show 24/07/06
> and so on.
>
> Office 2003.
>
> Thanks,
> kfh.
>

Cheers for that.
kfh.


"k f h" wrote:

>
> Hi All,
>
> Is there a way to replicate cells for a weekly basis. If I enter the
> 17/07/06 in one cell, can I replicate it in the next cell to show 24/07/06
> and so on.
>
> Office 2003.
>
> Thanks,
> kfh.
>