If there's a chance that you might delete row 1 then you'd have to hardcode
the date in the formula:

A1:

=DATE(2007,6,29)+(ROWS($1:1)-1)*7

Biff

"T. Valko" wrote in message
...
Try this:

A1 = date

=A$1+ROWS($1:1)*7

Biff

"Mike H" wrote in message
...
Both of these fornula go wrong if you delete a row. Any thoughts?

"T. Valko" wrote:

Enter the first date in a cell:

A1 = 6/29/2007

Enter this in A2 and copy down as needed:

=A1+7

Biff

"Eric" wrote in message
...
I am setting up a spreadsheet which only need consecutive dates which
are
Fridays.

Microsoft Excell 2003, SP2