HELP working days calculation

[jonny]

Hi Im new on here, I didnt know this forum existed. Its brilliant, If i knew it was here it wouyld have saved me so much time. Anyway, I wondered if any of you could help with this:

I have 3 dates

date1 = date new job recieved

date2 = date job started

date3 = date job finished

I want to be able to perform a calculation that, finds the later date out of date1 and date2 then with that date find the number of WORKING days between that and date3.

Im not bothered about bank holidays I just want the calculation to miss out Saturdays and Sundays.

Any help will be much appreciated, Im quite new to filemaker and at the moment I keep getting asked to do this and that and instead of taking a few minutes like something like this would, its taking me weeks to work out myslef. Thannks!!

[Lee Smith]

Hi Jonny,

Others may come up with a more eloquent one then this, but this seems to work.

Int((Date3 - If(Date2 >= Date1, Date2, Date1)) / 7) * 5 + Mod(Date3 - If(Date2 >= Date1, Date2, Date1), 7) - Case(DayofWeek(Date3) < DayofWeek(Date3), 2, 0)

HTH

Lee