Formula to drag accross and show just Workdays

Posted on 2011-10-21
Last Modified: 2012-05-12
Is there a way to write the workday formula so i can put it in one cell and drag it to the right and only populate only workdays?

Question by:KnutsonBM
    LVL 50

    Accepted Solution

    If you have start date in A2 put this formula in B2 and copy across


    If you want to exclude holidays too then you can include that range, e.g. with holidays in Z4:Z20


    rg=egards, barry

    LVL 6

    Author Comment

    aaaaaaaaah, i was looking at that (because i had done it before), went back to my spreadsheet and figured out my automatic calculation was turned off, thanks!


    Featured Post

    Courses: Start Training Online With Pros, Today

    Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

    Join & Write a Comment

    Drop Down List with Unique/Distinct Values (Part II - ComboBox or ListBox and Data Validation List Bonus!) David Miller (dlmille) Intro This article focuses on delivering unique, sorted lists to list objects (e.g., ComboBox, ListBox) and Dat…
    Improved? Move/Copy Add-in Replacement - How to avoid the annoying, “A formula or sheet you want to move or copy contains the name XXX, which already exists on the destination worksheet.” David Miller (dlmille)  It was one of those days… I wa…
    This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
    This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now