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" wrote in message
...

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.