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.