How do I set up a spreadsheet with repeating dates which are Frid.
 

I am setting up a spreadsheet which only need consecutive dates which are
Fridays.

Microsoft Excell 2003, SP2

How do I set up a spreadsheet with repeating dates which are Frid.
 

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

How do I set up a spreadsheet with repeating dates which are Frid.
 

Eric,

Put the dates of 2 consecutive Fridays in (say) A1 & a1 and select both cells
Hover over the bottom right hand corner of the lower cell until the cursir
turns in a cross and drag down.

Mike

"Eric" wrote:

I am setting up a spreadsheet which only need consecutive dates which are
Fridays.

Microsoft Excell 2003, SP2

How do I set up a spreadsheet with repeating dates which are Frid.
 

that is of course A1 & B1 !!

"Eric" wrote:

I am setting up a spreadsheet which only need consecutive dates which are
Fridays.

Microsoft Excell 2003, SP2

How do I set up a spreadsheet with repeating dates which are F
 

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

How do I set up a spreadsheet with repeating dates which are F
 

Enter this in A2 and copy down as needed:
=INDIRECT("A"&ROW()-1)+7

--
Berislav

Mike H wrote:
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



--
pozdrav!
Berislav

How do I set up a spreadsheet with repeating dates which are F
 

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

How do I set up a spreadsheet with repeating dates which are F
 

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