 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / November 2007Make a list of dates of all Fridays for 2002 thru 2007?
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  SignatureDennis Kessler http://www.denniskessler.com/acupuncture 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 > How can I make a list of the dates of all Fridays in the period beginning in > 2002 thru 2007, or year by year? [quoted text clipped - 6 lines] > Dennis Kessler > http://www.denniskessler.com/acupuncture Great. Thank you. about 52 rows per year. -DK In article <7a9ba24f-1d85-476e-b348-795835b3a296@e6g2000prf.googlegroups.com>, > Enter the date of the first Friday you want to start with in A1, eg > 04/01/2002 and put this formula in A2: [quoted text clipped - 18 lines] > > Dennis Kessler > > http://www.denniskessler.com/acupuncture You're welcome - thanks for feeding back. Pete > Great. Thank you. > [quoted text clipped - 29 lines] > > - Show quoted text - Enter 4/1/2002 in cell A1 Enter 11/1/2002 in cell A2 select both cells and pull left corner down. > How can I make a list of the dates of all Fridays in the period beginning > in [quoted text clipped - 3 lines] > > -Dennis Pull the lower RIGHT corner - the fill handle And I thought I was the only one who confused left & right! best wishes SignatureBernard 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 [quoted text clipped - 8 lines] >> >> -Dennis 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! [quoted text clipped - 11 lines] > >> > >> -Dennis The 'pull down' works (right corner), Thank you. -DK > Enter 4/1/2002 in cell A1 > Enter 11/1/2002 in cell A2 [quoted text clipped - 8 lines] > > > > -Dennis |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.