Results 1 to 5 of 5
  1. #1
    Join Date
    Jan 2008
    Posts
    1

    Unanswered: excel workday function question

    My workday function in excel (2003) is not working....[B]=workday(a1,b1).

    Column A1 = 1/21/08
    Column B1 = 1/14/08
    Column has the workday function listed above, and the answer it gives is 94715....it should be 5.

    Both Date columns are formatted for dates and the answer column is formatted for numbers.

    What could be happening?

  2. #2
    Join Date
    Jul 2003
    Location
    Amsterdam, Nederland
    Posts
    450

    try other function

    Have you checked the function datediff see F1 for the parameters
    it's quite simple

  3. #3
    Join Date
    Apr 2008
    Posts
    1
    Hey, if you got it all wrong, try to do it all over again instead of figuring out went wrong. It always work for me. Good luck!

  4. #4
    Join Date
    Apr 2004
    Location
    Derbyshire, UK
    Posts
    789
    Provided Answers: 1
    Hi

    According to my Excel Help WORKDAY() returns a DATE not a number of days (neeeds to formatted as a Date!). Apparantley the second argument should be a number of days NOT a date!?


    MTB

  5. #5
    Join Date
    Apr 2008
    Posts
    6
    I think this guy is wanting the 'networkdays' function rather than 'workday' function.

Posting Permissions

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