Results 1 to 4 of 4

NETWORKDAYS function minus 1 day

Threaded View

  1. #1
    Registered User
    Join Date
    01-06-2012
    Location
    Rochester NY
    MS-Off Ver
    Excel 2007
    Posts
    20

    NETWORKDAYS function minus 1 day

    Hello,

    I am currently working on a project that requires me to get the total number of business days between two dates. I have used the NETWORKDAYS function and it works great. However, I need a formula (if their is one) that will give me the total number of business days between the dates and either A) minus 1 from the total or B) not include the first day as an actual work day.

    example.

    Start date - 3/20/12
    End date - 3/23/12
    Total number of business days minus 1 = 3

    I can do this if i use the function, copy and paste special and then create another row next to the total and do a =A1-1 all the way down but was just wondering if their was an easier way.

    Any help with this would be much appreciated.
    Last edited by oniete1997; 03-20-2012 at 08:33 PM.

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