+ Reply to Thread
Results 1 to 4 of 4

Adding calendar functionality into a worksheet

  1. #1
    Registered User
    Join Date
    04-21-2009
    Location
    Birmingham, England
    MS-Off Ver
    Excel 2007
    Posts
    42

    Adding calendar functionality into a worksheet

    Hi,

    This may be a complete shot in the dark, but at work I've built an Excel (obv) calculator to work out the benefits people get. For a certain group of people who are on fixed term contracts, their holiday is calculated by the amount of complete working weeks in that contract. Is there a way for Excel to work out the number of working weeks (mon-fri) in a contract if I were to add in the start and end dates? This would have to have some kind of calendar functionality as it would need to know what day the start and end dates are.

    Any help much appreciated

    Jon

  2. #2
    Valued Forum Contributor squiggler47's Avatar
    Join Date
    02-17-2009
    Location
    Littleborough, UK
    MS-Off Ver
    Excel 3.0 to 2007+2010! (couldnt get 2.1 working)
    Posts
    1,013

    Re: Adding calendar functionality into a worksheet

    try networkdays(StartDate,EndDate)!

    divide by 5 to get work weeks!

  3. #3
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: Adding calendar functionality into a worksheet

    Just an addition to squiggler47's post, NETWORKDAYS forms part of the Analysis ToolPak (also referred to as ATP) add-in which can be activated (if not already) via Tools -> Addins.

  4. #4
    Registered User
    Join Date
    04-21-2009
    Location
    Birmingham, England
    MS-Off Ver
    Excel 2007
    Posts
    42

    Talking Re: Adding calendar functionality into a worksheet

    Thanks to both of you, that's a great help!

    Jon

+ Reply to Thread

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