Thread: Replicating
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Franz Verga Franz Verga is offline
external usenet poster
 
Posts: 459
Default 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