+ Reply to Thread
Results 1 to 3 of 3

Excel 2003 - Calculate working days and holidays

  1. #1
    Registered User
    Join Date
    12-01-2012
    Location
    Edinburgh
    MS-Off Ver
    Excel 2007 (w) 2013 (h)
    Posts
    13

    Excel 2003 - Calculate working days and holidays

    Hello and thanking you in advance for any responses

    I am using excel 2003 and need to detremine the number of working days ( Monday to Friday) , excluding any holidays from the current date.

    Excel 2003 does not have the functionality to do this with a set formula. (or am i missing something?)

    I have set todays date using the Today() function in cell B2 and wish to use this to calculate overdue dates accordingly. My received dates are entered into (cell B3, continuing down the column) which is the date i wish make calculation from. The number of overdue days are to show in cell A3, and continuing down the same column. The number of overdue days is to increase each day.

    My problem is that without having the "workdays" set formula I am having difficulties in setting a formula to exclude weekends and holidays.

    Please advise, much appreciated and happy 2013

    Regards

    Meckenzie

  2. #2
    Forum Expert ConneXionLost's Avatar
    Join Date
    03-11-2009
    Location
    Victoria, Canada
    MS-Off Ver
    2010
    Posts
    2,952

    Re: Excel 2003 - Calculate working days and holidays

    If you go to "Tools > Add-Ins..." and use the "Analysis ToolPak", you will then be able to use the NETWORKDAYS function. It should help.
    Would you like to say thanks? Please click the: " Add Reputation" button, on the grey bar below the post.

  3. #3
    Forum Expert Kevin UK's Avatar
    Join Date
    12-07-2010
    Location
    Radstock, Somerset
    MS-Off Ver
    365
    Posts
    1,922

    Re: Excel 2003 - Calculate working days and holidays

    Hi meckenzie2012

    Have a look at the Networkdays function.

    Have alook here:
    http://www.myonlinetraininghub.com/e...kdays-function
    Regards Kevin


    Merged Cells (They are the work of the devil!!!)

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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