AnsweredAssumed Answered

Exclude Friday from calculated date

Question asked by Pam on Jun 21, 2010
Latest reply on Jun 22, 2010 by Pam


Exclude Friday from calculated date


I am a novice user of FileMaker (v Pro 10) on a Mac. (have used neither before).

I need to calculate a date 10 days from 'start date', which is a field in a table. If the result is a Friday, then the calculation should be 'start date' + 11. Tried to do this by means of an if statement, but can't figure out the correct wording to exclude Fridays.

I am in Dubai in the UAE, so unsure if Friday is day 6 or not.

Would be grateful for any assistance, I am under pressure to get the DB up and running.

Thanks P