+ Reply to Thread
Results 1 to 7 of 7

Calculate END DATE based on START DATE & No of working days

  1. #1
    Registered User
    Join Date
    08-28-2012
    Location
    Sri Lanka
    MS-Off Ver
    Excel 2010
    Posts
    57

    Calculate END DATE based on START DATE & No of working days

    Hi All

    once agian expect your valuable ideas to solve my problem. I tried different ways to solve this but struck at some formulaes.

    I need to calculate END DATE based on saturday as a half day & sunday as a holiday. To give you clear idea pls see my sample sheet as attached.

    Rgds
    Prashantha
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor abduljaleel.mca's Avatar
    Join Date
    02-13-2013
    Location
    Chennai, India
    MS-Off Ver
    MS 365 Business
    Posts
    326

    Re: Calculate END DATE based on START DATE & No of working days

    Try this....
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    08-28-2012
    Location
    Sri Lanka
    MS-Off Ver
    Excel 2010
    Posts
    57

    Re: Calculate END DATE based on START DATE & No of working days

    Hi Abdul

    Thank you for quick help. My actual work sheet contains 300 - 400 rows & need to derive END DATE agianst each & every START DATE. Further calculation need to be happen as data entered to A column. Can you pls look for help me. pls see sample wookbook.

    Prashantha
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    08-28-2012
    Location
    Sri Lanka
    MS-Off Ver
    Excel 2010
    Posts
    57

    Re: Calculate END DATE based on START DATE & No of working days

    Hi Abdul

    With your sugestion you have partly solved my problem. thanks. Can u rewrite the code in order to calculate END DATE with change cell value event(A5)

    thank u
    Prashantha

  5. #5
    Valued Forum Contributor abduljaleel.mca's Avatar
    Join Date
    02-13-2013
    Location
    Chennai, India
    MS-Off Ver
    MS 365 Business
    Posts
    326

    Re: Calculate END DATE based on START DATE & No of working days

    Hope it will help you out...
    Attached Files Attached Files
    Last edited by abduljaleel.mca; 11-20-2013 at 02:05 AM.

  6. #6
    Registered User
    Join Date
    08-28-2012
    Location
    Sri Lanka
    MS-Off Ver
    Excel 2010
    Posts
    57

    Re: Calculate END DATE based on START DATE & No of working days

    Hi Abdul

    Yes u saved me. u r a genius. thank you very much

    Prashantha

  7. #7
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Calculate END DATE based on START DATE & No of working days

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

+ 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: 8
    Last Post: 05-10-2013, 05:37 AM
  2. Replies: 0
    Last Post: 03-21-2013, 12:22 PM
  3. Replies: 1
    Last Post: 08-22-2012, 10:38 AM
  4. Calculate start date based on working hours and end date
    By kaaver in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-28-2010, 06:58 AM
  5. Start Date, End Date=#of days not working
    By readingteacher in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-19-2007, 06:43 PM

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