Weekday versus weekend

[Jackie Z.]

Hi there!

I'm a staffing agency owner and I'm writing an email script that will confirm to my clients the last day of an employee's temp-to-hire term. A temp-to-hire (TTH) assignment is roughly 90 days from the employee's start date.

My TTH end-date field currently calculates the start date + 90 (date_start + 90), but I'd like it to round down to the nearest Friday. So, if the calculation lands on a Sunday, I'd like it to round to the previous Friday.

I could also use a calculation that rounds to the nearest weekday.

Anyone? Thank you. My developer is on vacation. :(

[Fitch]

http://help.filemaker.com/app/answers/detail/a_id/5053/~/calculating-a-weekday-date