Results 1 to 5 of 5
  1. #1
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Don't count weedends (2000)

    Try NetWorkdays for a date difference excluding weekends and (optional) Holidays:

    =NETWORKDAYS(start_date,end_date,holidays)
    [Note: requires the Analysis toolpack]
    Steve

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Don't count weedends (2000)

    Workday (there is no "s") calcs a date a given number of days past the startdate (ignoring weekends and holidays). It does not give a date difference.

    It is also not "built-in", it requires the analysis toolpack.

    Steve

  3. #3
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Vienna, Wien, Austria
    Posts
    5,009
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Don't count weedends (2000)

    Look at the WORKDAY function built in to the Analysis Toolpak. HTH
    Gre

  4. #4
    2 Star Lounger
    Join Date
    Dec 2002
    Posts
    192
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Don't count weedends (2000)

    Steve,
    thank you for the quick response on the =NETWORKDAYS. You are a lifesaver! I owe you big time

  5. #5
    2 Star Lounger
    Join Date
    Dec 2002
    Posts
    192
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Don't count weekends (2000)

    Hi
    I have a meeting in 2 hours and I can not remember how to count between 2 dates without couting the weekends.
    Some of my dates go from Thursday to a Monday but I can't have the 2 days of the weedend counted
    Please help

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •