![]() |
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. |
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 |
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. |
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