Syntax for Excel 2003 instead of 2007

Posted on 2011-04-22
Last Modified: 2013-11-05
I have this in a cell using Office 2007 but it doesn't work for users with 2003.  Can someone suggest a change so it will work with 2003?  (Holidays is a named range on the spreadsheet)

=WORKDAY(H4, -1, Holidays)

Question by:SteveL13
    LVL 81

    Accepted Solution

    That function is in Excel 2003. It requires the Analysis ToolPak. To enable the Analysis ToolPak, choose the menu command Tools->Add-Ins, check on Analysis ToolPak, and click OK.

    LVL 81

    Expert Comment

    by:zorvek (Kevin Jones)
    You will find here a formula that you can use instead of WORKDAY:

    Title: Replacing the Analysis Toolpak Addin - Part 2

    Once you look at it though I think you will agree it is probably better to just add the Analysis Toolpak.

    LVL 50

    Expert Comment

    by:barry houdini
    If you always want the previous workday then you can make that a bit simpler, i.e. using this formula


    That assumes that you never have more then 5 successive non-working days (either holidays or weekends)

    regards, barry

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Better Security Awareness With Threat Intelligence

    See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

    Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
    Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
    The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
    The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

    759 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

    8 Experts available now in Live!

    Get 1:1 Help Now