Results 1 to 3 of 3

Autofill weekdays/skip weekends in a month

Threaded View

  1. #1
    Registered User
    Join Date
    11-30-2009
    Location
    Tavernier, FL USA
    MS-Off Ver
    Excel 2007
    Posts
    2

    Autofill weekdays/skip weekends in a month

    I would like to be able to auto fill weekdays (skipping Saturday & Sunday) in a month. For example, my spreadsheet would look like this if cell A1 contains12/01/09:



    DATE WORKDAYS TASK

    1-Dec 1 AP CLOSE - CAPITAL & POS ITEMS
    1-Dec 1 POS MONTH END
    1-Dec 1 HEALTH INSURANCE
    2-Dec 2 DEPR SYSTEM RUN; INCL-SOFTWARE AMORT
    2-Dec 2 SPECIAL EQUIPMENT
    4-Dec 4 PRELIMINARY ENERGY REPORT
    7-Dec 5 AP CLOSE - ALL OTHER ITEMS


    The DATE column needs to return the date for WORKDAYS listed...Monday through Friday only. The first workday in Dec 2009 is 12/1, the fifth workday is 12/7, and so on...

    Thanks!
    Last edited by Sandra A; 11-30-2009 at 03:34 PM. Reason: Format wrong

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