+ Reply to Thread
Results 1 to 2 of 2

Networkdays.Intl, incorrect result in one row

  1. #1
    Registered User
    Join Date
    06-22-2009
    Location
    Kuwait
    MS-Off Ver
    Excel 2010
    Posts
    59

    Networkdays.Intl, incorrect result in one row

    Hi all,

    I am using the below formula to achieve the result of Networkdays which include the weekends. And if the leave is other than Annual, I just need to get total days between start date and end date. This is working fine but in one row it is giving the wrong result, the row C36=Sick, D36=start date (9/13/2014), E36=end date (10/27/2014), the result in F36=14 which actually should be 45. When I check the result in formula bar with f9 key it is showing the correct number 45 but in the cell it is showing 14, what could be the reason?

    Please Login or Register  to view this content.
    Please Login or Register  to view this content.
    Last edited by razaas; 10-22-2014 at 07:07 AM.

  2. #2
    Registered User
    Join Date
    06-22-2009
    Location
    Kuwait
    MS-Off Ver
    Excel 2010
    Posts
    59

    Re: Networkdays.Intl, incorrect result in one row

    Hi all,

    It was a cell format problem, I changed the cell format to General and the result is correct now.

    Thanks

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Networkdays Returns Incorrect Number Of Days
    By goss in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-23-2014, 10:44 AM
  2. [SOLVED] Looking for alternative to NETWORKDAYS.INTL
    By Jaron_t in forum Excel General
    Replies: 4
    Last Post: 05-21-2012, 04:54 PM
  3. isblank & vlookup formula returns #n/a result and incorrect result
    By helpmeplease333 in forum Excel General
    Replies: 5
    Last Post: 05-06-2012, 11:41 PM
  4. [SOLVED] vlookup based on random result returns incorrect result
    By rickat in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-05-2005, 09:20 AM
  5. [SOLVED] Excel NETWORKDAYS - incorrect results
    By Patricia in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-19-2005, 08:06 AM

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