View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Carl R[_2_] Carl R[_2_] is offline
external usenet poster
 
Posts: 15
Default enter date every 7 days

I am creating a wk book and want my dates to be every 7 days. Want it to
look like this
12/20/2009
12/27/2009
1/3/2010
1/10/2010
and so on.. is this a formula thing? I know how to drag the the first
cell and it will populate by 1 but can this be done by every 7th day?
--
Microsoft Office 2003 Version
Students and Teachers Edition
Windows Vista Home Premium

Thank-you
Carl R