Make a list of dates of all Fridays for 2002 thru 2007?

  • Thread starter Thread starter dk_
  • Start date Start date
D

dk_

How can I make a list of the dates of all Fridays in the period beginning in
2002 thru 2007, or year by year?

Thanks.

-Dennis
 
Enter the date of the first Friday you want to start with in A1, eg
04/01/2002 and put this formula in A2:

=A1+7

Format that cell as a date and copy it down for as many rows as you
need (about 365 rows).

Hope this helps.

Pete
 
Enter 4/1/2002 in cell A1
Enter 11/1/2002 in cell A2

select both cells and pull left corner down.
 
Pull the lower RIGHT corner - the fill handle
And I thought I was the only one who confused left & right!
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

Just Merks said:
Enter 4/1/2002 in cell A1
Enter 11/1/2002 in cell A2

select both cells and pull left corner down.
Click to expand...
 
Great. Thank you.

about 52 rows per year.

-DK


Pete_UK said:
Enter the date of the first Friday you want to start with in A1, eg
04/01/2002 and put this formula in A2:

=A1+7

Format that cell as a date and copy it down for as many rows as you
need (about 365 rows).

Hope this helps.

Pete
Click to expand...
 
The 'pull down' works (right corner),

Thank you.

-DK




Just Merks said:
Enter 4/1/2002 in cell A1
Enter 11/1/2002 in cell A2

select both cells and pull left corner down.
Click to expand...
 
Thanks for the corner correction. I was thinking, well maybe the left is in
a newer version of Excel. ...probably not. ;)

-DK




Bernard Liengme said:
Pull the lower RIGHT corner - the fill handle
And I thought I was the only one who confused left & right!
best wishes
Click to expand...
 
Back
Top