No. days between dates excl. Sat & Sun ie work days only
MZ Tools makes life easier for the Excel VBA coder
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: No. days between dates excl. Sat & Sun ie work days only

  1. #1
    Guest

    Default

     
    Is it possible to have a formula which calculates the no. of days between 2 dates, but excludes Sat & Sun?

    e.g. 04/02/02 & 16/02/02 = 10 working days

  2. #2
    New Member
    Join Date
    Feb 2002
    Location
    McKinney Texas
    Posts
    6
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    On 2002-02-19 11:30, Anonymous wrote:
    Is it possible to have a formula which calculates the no. of days between 2 dates, but excludes Sat & Sun?

    e.g. 04/02/02 & 16/02/02 = 10 working days
    You can use =NETWORKDAYS(A1,A2) Assuming that A1 contains the start date, and A2 contains the end date.

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com