G
Guest
I am setting up a spreadsheet which only need consecutive dates which are
Fridays.
Microsoft Excell 2003, SP2
Fridays.
Microsoft Excell 2003, SP2
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
T
T. Valko
Enter the first date in a cell:
A1 = 6/29/2007
Enter this in A2 and copy down as needed:
=A1+7
Biff
A1 = 6/29/2007
Enter this in A2 and copy down as needed:
=A1+7
Biff
G
Guest
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
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
G
Guest
that is of course A1 & B1 !!
G
Guest
Both of these fornula go wrong if you delete a row. Any thoughts?
B
b&s
Enter this in A2 and copy down as needed:
=INDIRECT("A"&ROW()-1)+7
=INDIRECT("A"&ROW()-1)+7
T
T. Valko
Try this:
A1 = date
=A$1+ROWS($1:1)*7
Biff
A1 = date
=A$1+ROWS($1:1)*7
Biff
Mike H said:Both of these fornula go wrong if you delete a row. Any thoughts?
T
T. Valko
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
the date in the formula:
A1:
=DATE(2007,6,29)+(ROWS($1:1)-1)*7
Biff