none
Wrong answer to question ... but thread is locked.

    Question

  • Hey guys,

    i was looking for a solution for the problem described in this thread:

    http://social.msdn.microsoft.com/Forums/sharepoint/en-US/d6a6b014-c09c-4436-9f18-0f151bae85b5/caculated-column-formula-for-workdays-between-two-dates-excluding-weekends-datediff?forum=sharepointcustomizationlegacy

    I was looking over the formula that was marked as answer and (in case im not wrong) checked it. In my view this answer isnt correct. Proof:

    Just one scenario to show it: Assume starting day is thursday and end is a sunday 2 weeks later for example. Because Sunday is later than Friday the IF-condition is false and the ELSE-statement is done. Here only 2 weekends are taken out of the total difference though there are 3 in this time span. (because the FLOOR rounds down which brings wrong results).

    Well maybe it takes some time to figure out not working on this, but my MAIN issue here is that this thread is LOCKED and i cant even discuss or respond and the guys are probably using a wrong formula.

    Any help / suggestions?

    Regards

    Patrick

    Wednesday, July 2, 2014 1:57 PM

All replies

  • Hi Patrick,

    Considering that the thread you've linked to is from 2009, I'm not totally surprised that it's locked. The OP appears to still be an active user here on the forums, but everyone else from that thread hasn't been active for at least a few months (or years).

    You can always start a new thread and provide a link back to that thread as background for anyone reading your thread.


    Don't retire TechNet! - (Don't give up yet - 12,950+ strong and growing)

    • Proposed as answer by Just Karl Monday, July 7, 2014 2:52 PM
    Wednesday, July 2, 2014 2:41 PM