number of business days

[elvis_impersonating_penguin]

ok.. I am pretty sure I have seen this before, but I am unable to find it.

I have two date fields, AssignDate and CompleteDate. What I need is a calculation that returns the difference (in days) between these dates, but only accounting for business days (Monday through Friday).

using Filemaker 6.

[elvis_impersonating_penguin]

ok.. i guess i should have looked harder. I just was able to find what I was looking for on databasepros website with there "Work days" files. I never found anything because I only searched for the phrase "Business Days".. anyway here is the calc i ended up with. if anyone sees any problems let me know, because I am only half sure how it works.

Thanks

Rick

If(not IsEmpty(PJCompleteDate),

Int((PJCompleteDate + Case(DayofWeek(PJCompleteDate) = 1, 1, DayofWeek(PJCompleteDate) = 7, 2) - PJAssignDate + Case(DayofWeek(PJAssignDate) = 1, 1, DayofWeek(PJAssignDate) = 7, 2)) / 7) * 5 +

Mod(PJCompleteDate + Case(DayofWeek(PJCompleteDate) = 1, 1, DayofWeek(PJCompleteDate) = 7, 2) - PJAssignDate + Case(DayofWeek(PJAssignDate) = 1, 1, DayofWeek(PJAssignDate) = 7, 2), 7) -

Case(DayofWeek(PJCompleteDate + Case(DayofWeek(PJCompleteDate) = 1, 1, DayofWeek(PJCompleteDate) = 7, 2)) < DayofWeek(PJAssignDate + Case(DayofWeek(PJAssignDate) = 1, 1, DayofWeek(PJAssignDate) = 7, 2)), 2)

,"")

[Navigating]

You saved my life with this calc.

Thanks!

Sheryl