Results 1 to 8 of 8

Displaying the Weeks in a Selected Month

Threaded View

  1. #1
    Forum Contributor
    Join Date
    04-02-2010
    Location
    penrith
    MS-Off Ver
    Excel 2007
    Posts
    522

    Displaying the Weeks in a Selected Month

    Hi I have a workbook that needs to display the relevent weeks in month, the dates would be the start and end dates of each wekk (monday to Friday) but also need to take into consideration, partial weeks i.e. only a wednesday, thursday and friday at the start of the month given where the first available date falss on.

    Please see the attached sheet for reference, I am looking to do this with as few formulas as possible please.

    It also needs to show a list of monday only dates for the selected month.

    Thanks in advance

    John Dalton
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 2
    Last Post: 01-30-2013, 03:16 AM
  2. fill a row with weeks of a particular month
    By roninn75 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-15-2013, 09:30 AM
  3. No of weeks (Wednesdays)in month
    By GerryA in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-14-2012, 02:51 AM
  4. Excel 2007 : Timeline month/days to month/weeks?
    By Bellaggio1770 in forum Excel General
    Replies: 12
    Last Post: 04-14-2012, 05:09 PM
  5. Need help to separate month in weeks
    By bluejohn in forum Excel General
    Replies: 0
    Last Post: 01-14-2011, 03:57 AM

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