Work Days Difference, Need Same Day = 1

[fbenjamin]

Greetings,

I'm working on a query that returns the work days difference between two dates, and divides that by a larger number of days to get a percentage. I need dates that are the exact same to return a value of 1, so that when it does the division it's not dividing 0, and eventually returning an #error further in my calculations.

I'm currently using funWorkDaysDifference

Would appreciate any suggestions!

 

[Brianwarnock]

Greetings,

I need dates that are the exact same to return a value of 1,

I'm currently using funWorkDaysDifference

Would appreciate any suggestions!

I don't know the code for this function but I would expect it to return 1 in this circumstance, unless the date was a holiday or weekend.

Brian