+ Reply to Thread
Results 1 to 5 of 5

Calendar Creation Weekday Only

  1. #1
    Registered User
    Join Date
    11-24-2012
    Location
    Annapolis, Maryland
    MS-Off Ver
    Excel 2010
    Posts
    36

    Calendar Creation Weekday Only

    Greetings!

    Looking for a way to generate a calendar, listing weekdays only.

    See the attached. Cells A1 and A2 identify earliest and latest dates from a range, not included within the attachment. The related min max formulae are not within these cells.

    The desired result listing all weekdays from and including the min value (02/03/2014) to and including the max day (02/28/2014) are identified in A4:T4.

    Note: If solved via formula, range will need to be extended from T4 manually, so I am hoping that something like a "fill" formula could be used so there will be no need to manually identify T4 equivalent as the outside part of the range.

  2. #2
    Forum Expert daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    Microsoft 365
    Posts
    14,700

    Re: Calendar Creation Weekday Only

    Put this formula in A4 and copy as far across as you need and more

    =IF(WORKDAY($A1-1,COLUMNS($A4:A4))>$A2,"",WORKDAY($A1-1,COLUMNS($A4:A4)))

    You'll get blanks when valid dates run out
    Audere est facere

  3. #3
    Registered User
    Join Date
    11-24-2012
    Location
    Annapolis, Maryland
    MS-Off Ver
    Excel 2010
    Posts
    36

    Re: Calendar Creation Weekday Only

    Very Nice! It works.

    Caution: Will note in file that column insert will change outcome (in other words, do not delete or add columns).

    Thank you.

    Will mark as solved.

  4. #4
    Forum Expert daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    Microsoft 365
    Posts
    14,700

    Re: Calendar Creation Weekday Only

    No problem

    In fact as long as you copy the formula into enough empty columns you can delete columns without creating a gap in the dates....and if you insert columns you only need to copy the formula into the new columns and the dates will still be continuous.

    That is the very reason why I used COLUMNS function, rather than COLUMN, it's more robust when you delete/insert columns
    Last edited by daddylonglegs; 03-05-2014 at 04:43 PM.

  5. #5
    Registered User
    Join Date
    11-24-2012
    Location
    Annapolis, Maryland
    MS-Off Ver
    Excel 2010
    Posts
    36

    Re: Calendar Creation Weekday Only

    Great points on the column insertion and deletion issue. Thanks again.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Calendar creation from dates on various Worksheets
    By wrestlingnrj in forum Excel General
    Replies: 3
    Last Post: 03-22-2013, 07:05 AM
  2. Weekday Calendar Function
    By willmeister in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-16-2011, 12:45 AM
  3. Monthly calendar creation
    By haali in forum Excel General
    Replies: 6
    Last Post: 11-14-2011, 09:04 AM
  4. Calendar Creation
    By COMTEC in forum Excel General
    Replies: 2
    Last Post: 11-15-2010, 01:25 PM
  5. Calendar Creation in Excel
    By Duncan Edment in forum Excel General
    Replies: 7
    Last Post: 03-02-2005, 06:06 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