Future Date Formula

Well, based on what you've said, your formula is going to be a bit of a bear because you'll have to setup each option under 'Recurrence' with multiple output values (see the CASE formulas below). With that said, for the selection you've identified, I would suggest this:

var number one = Case([Recurrence],
                         "Mid-Month: 16th and 23rd",16,
                         "Second Option",{1st number of 2nd Option},etc..);

var number two = Case([Recurrence],
                         "Mid-Month: 16th and 23rd",23,
                         "Second Option",{2nd number of 2nd Option},etc..)

var number d = Day([Most Recent Production Run Date]);
var number m = Month([Most Recent Production Run Date]);
var number y = Year([Most Recent Production Run Date]);
var number dd = IF($d = $one,$two,$one);
var number mm = IF($d = $one,$m,Month(AdjustMonth([Most Recent Production Run Date],1);
var number yy = IF($d = $one,$y,Year(AdjustMonth([Most Recent Production Run Date],1);

Date($yy,$mm,$dd)​

------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quickbase Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------