Results 1 to 5 of 5

Excel 2007 : Start and End of 52 Weeks for 2009?

Threaded View

  1. #1
    Registered User
    Join Date
    08-05-2006
    Posts
    63

    Start and End of 52 Weeks for 2009?

    Fellow Forum Members,

    How can I make Excel automatically autofill "column A" with 52 weeks for the entire year of 2009 as shown below.

    2/1/2009 - 2/7/2009
    2/8/2009 - 2/14/2009
    2/15/2009 - 2/21/2009
    2/22/2009 - 2/28/2009 and so on to Dec 2009.

    The week starts on Sunday (i.e 2/1/2009) and ends on Saturday (i.e. 2/7/2009) and both dates need to be in one cell.
    Any help greatly appreciated. Thanks.
    Last edited by binar; 02-01-2009 at 10:13 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1