ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Replicating (https://www.excelbanter.com/excel-discussion-misc-queries/99599-replicating.html)

k f h

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.


Franz Verga

Replicating
 
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



Bob Phillips

Replicating
 
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.




k f h

Replicating
 
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.



All times are GMT +1. The time now is 04:10 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com