Results 1 to 7 of 7

# of Workdays minus Holidays

Threaded View

jmozulay # of Workdays minus Holidays 10-11-2007, 10:54 AM
oldchippy See other question ... 10-11-2007, 10:58 AM
daddylonglegs Can you give an example? ... 10-11-2007, 11:12 AM
oldchippy NETWORKDAYS This function... 10-11-2007, 11:15 AM
jmozulay Perfect thanks! 10-11-2007, 11:52 AM
daddylonglegs ?? Are you sure ?? ... 10-11-2007, 11:56 AM
oldchippy Yes you're right... 10-11-2007, 04:33 PM
  1. #1
    Registered User
    Join Date
    10-09-2007
    Posts
    4

    # of Workdays minus Holidays

    When trying to find the number of workdays between two dates minus holidays, excel says to use NETWORKDAYS(start_date,end_date,holidays). I tried this and ended up getting one less day regardless if the holiday fell between the two dates. I made sure that the dates weren't formatted as text. What am I doing wrong?

    Thanks!
    Last edited by VBA Noob; 10-11-2007 at 10:56 AM.

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