+ Reply to Thread
Results 1 to 4 of 4

Workday , Holidays - Comapring Previous Date and Days of Working

  1. #1
    Registered User
    Join Date
    09-11-2013
    Location
    India
    MS-Off Ver
    trunaua scaring
    Posts
    3

    Workday , Holidays - Comapring Previous Date and Days of Working

    I have following Data.

    srno days for drilling days for rolling days for welding Date for drilling Date for rolling Date for welding date for Dispatch
    1 0.89 2 0.35 29th Oct 2013
    2 1 0.66 7 29th Oct 2013



    I already have a Dispatch date for the job. I also have days required to complete activites such as Drilling , Rollling And Welding.

    So What i want to do is calculate date for welding , rolling and drilling in backward position.

    But i want to ignore weekends i.e. Saturdays and Sundays.

    I also want to ignore Vacations/Holidays.i.e. Suppose i have a official holiday on say 28th Oct 2013.

    So my RESULT TABLE LOOKS LIKE THIS.

    Sr NO days for drilling days for rolling days for welding Date For Drillling Date for rolling Date for welding Date for Dispatch
    1 .89 2 .35 23rd Oct 2013 24th Oct 2013 29th Oct 2013 29th Oct 2013
    2 1 0.66 7 15th Oct 2013 16th Oct 2013 17th Oct 2013 29th Oct 2013

    I am using formulae
    =workday(date for dispatch,rows(same row:same row),(ref to list of holidays)-days required

    This is not working. NEED HELP.

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: Workday , Holidays - Comapring Previous Date and Days of Working

    Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic

  3. #3
    Registered User
    Join Date
    09-11-2013
    Location
    India
    MS-Off Ver
    trunaua scaring
    Posts
    3

    Re: Workday , Holidays - Comapring Previous Date and Days of Working

    Plz refer attachment .

    URGENT
    Attached Files Attached Files

  4. #4
    Valued Forum Contributor
    Join Date
    10-14-2012
    Location
    Netherlands
    MS-Off Ver
    Excel 2019
    Posts
    353

    Re: Workday , Holidays - Comapring Previous Date and Days of Working

    You can do it with Excel2010 function: WORKDAY.INTL()
    see attachment............
    Attached Files Attached Files
    Kind regards,
    Piet Bom

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 10
    Last Post: 02-29-2024, 08:55 AM
  2. [SOLVED] Calculate working days excluding holidays from Jan 11 to Dec 13
    By Cortlyn in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-24-2013, 09:46 AM
  3. Excel 2003 - Calculate working days and holidays
    By meckenzie2012 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-10-2013, 02:12 PM
  4. Previous working days date (Mon-Fri working week).
    By intothewild in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-22-2011, 01:00 PM
  5. Replies: 8
    Last Post: 09-01-2010, 11:00 AM

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