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

[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

 

[Pete_UK]

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

 

[Just Merks]

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

select both cells and pull left corner down.

 

[Bernard Liengme]

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

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

select both cells and pull left corner down.

 

[dk_]

Great. Thank you.

about 52 rows per year.

-DK

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

 

[dk_]

The 'pull down' works (right corner),

Thank you.

-DK

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

select both cells and pull left corner down.

 

[dk_]

Thanks for the corner correction. I was thinking, well maybe the left is in
a newer version of Excel. ...probably not.

-DK

Pull the lower RIGHT corner - the fill handle
And I thought I was the only one who confused left & right!
best wishes

 

[Pete_UK]

You're welcome - thanks for feeding back.

Pete

Great. Thank you.

about 52 rows per year.

-DK







- Show quoted text -