+ Reply to Thread
Results 1 to 6 of 6

Due date formula - 13-working day SLA calculation

  1. #1
    Registered User
    Join Date
    11-06-2012
    Location
    England
    MS-Off Ver
    Excel 2007
    Posts
    3

    Due date formula - 13-working day SLA calculation

    Hello all

    I have a report I pull from our system that I need to alter so that a due date is calculated based on the date received.

    To give you an idea we receive an item, then there is a 13 working day period between the date received and the date the item will be at the site it was returned from.

    Is there a simple or perhaps even complicated function that would perform this?

    I have a date received column, date logged column and date completed column and was hoping to at a due date column that calculates based on the date received.

    Hope this makes sense, please let me know if you need any more information.

    Thanks

    Rob

  2. #2
    Valued Forum Contributor
    Join Date
    08-14-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    573

    Re: Due date formula - 13-working day SLA calculation

    Have you tried networkdays function?

    Please upload a workbook with example.

  3. #3
    Registered User
    Join Date
    11-06-2012
    Location
    England
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Due date formula - 13-working day SLA calculation

    Please see attached example

    I have tried various formulas but I'm not exactly adept with Excel as a whole, and have always just figured little things out up until now. Just couldn't get my head around this one.

    Thanks
    Attached Files Attached Files

  4. #4
    Forum Contributor
    Join Date
    11-05-2012
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    229

    Re: Due date formula - 13-working day SLA calculation

    It is actually very simple. Use the formula =Workday(start_date,days,[holidays]). I've done this for you...

    Copy of Example.xlsx
    Last edited by TheExcelphile; 11-06-2012 at 09:21 AM.
    Taming the Excel dragon... www.TheExcelphile.com

  5. #5
    Registered User
    Join Date
    11-06-2012
    Location
    England
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Due date formula - 13-working day SLA calculation

    Wow! Thank you.

    I should really take up some lessons, or buy a book on it!

    Thanks again - much appreciated

    Rob

  6. #6
    Forum Contributor
    Join Date
    11-05-2012
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    229

    Re: Due date formula - 13-working day SLA calculation

    You are welcome

+ 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