View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Duke Carey Duke Carey is offline
external usenet poster
 
Posts: 1,081
Default Date calculation

Make sure that your cells are formatted as date. If your first date is in
cell A1, then use this formula in A2

=A1+7

and copy down as far as needed

"Faith" wrote:

Hi! Can someone tell me how to do this date calculation: I have entered a
starting date (September 1, 2007), and I want to create a calculation that
adds one week to that date over a series of cells (September 1 plus 7 days;
September 8 plus 7 days, and so on). Thanks!