Auto-fill fields with calculation
I am trying to find a way for FM to auto fill dates based on the date I put in one "master" field. Hopefully the explanation below is enough to explain.
Master Field - Jan 1
Field 1 = 2 days later than master field or Monday January 3rd
Field 2 = 4 days later than master field or Wednesday January 5th
Field 3 = 7 days later than master field or Saturday January 8th **BUT** if this day lands on a Saturday it needs to subtract a day and land on Friday January 7th. (in other words, field 1, 2, 3, etc. can only equal a Mon-Fri business day).
Field 4 = 8 days later than master field or Sunday January 9th **BUT** if this day lands on a Sunday it needs to add a day and land on Monday January 10th.
Any ideas? Thanks!