Workdays Function - Need to allow for return to be Negative

[johnny51981]

Hello!
I have built in the Workdays function straight off of this Microsoft Link. But it seems that it will only return positive numbers. What I am looking to do is show the number of days a forecast date is out from the current date. If that forecast date is PRIOR TO the current date, I would like to see how many workdays prior that forecast date is, showing in the negative.



Is that a possibility?

[June7]

Certainly. Change that code that checks for -1 value and exits the sub.

For a start, remove or comment out:

    If nWeekdays = -1 Then
        Workdays = -1
        GoTo Workdays_Exit
    End If

[johnny51981]

So, if I comment out just what you have provided above, nothing changes and all of my counts are still in the positive, even when I know there are to be negatives due to dates passed.

[ssanfu]

Did you trace the code??
Single step through the code. You will find code in the Weekdays function that swaps the dates if the start date is less than the end date. Comment out that part of the code to get negative numbers. Hint: read the comments.

[johnny51981]

That did it. Thank you both!