One way:

A1: 1/1/2006
B1: =A1+7

Format both as mmm d yyyy


In article ,
wrote:

HIya,

I was wondering if Excel 2003, was capable of creating dates
*automatically* 7 days apart?

If I gave Excel an example could it extrapolate from that, the
beginning dates and end dates for the rest of the year?

Here's an ***arbitrary example:*** (all dates are in separate cells)

Jan 1 2006 Jan 8 2006

Thanks in advance.