+ Reply to Thread
Results 1 to 3 of 3

Formula to Calculate End Date by excluding Fridays,Saturdays & Holidays

  1. #1
    Forum Contributor
    Join Date
    05-04-2009
    Location
    ME
    MS-Off Ver
    Excel 2003,2007
    Posts
    157

    Formula to Calculate End Date by excluding Fridays,Saturdays & Holidays

    Hi Everyone,

    Assume I have start date of a project (eg: 1-Nov-2012) and looking for a formula to calculate end date. Considering project duration is 100 Days by excluding Fridays & Saturdays and listed holidays.

    I have tried Workday formula, but it considering only standard weekends . Highly appreciate your valuable inputs.


    Thanks & Regards,
    Nawas

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

    Re: Formula to Calculate End Date by excluding Fridays,Saturdays & Holidays

    Answer deleted duplicate post

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

    Re: Formula to Calculate End Date by excluding Fridays,Saturdays & Holidays

    Welcome to the Forum, unfortunately:

    This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

    Thread Closed.

+ 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