I have a scheduling calculator primarily based on 3 date picker fields (Every Monday, 2nd Tuesday, and 1st&3rdTuesday). The date is manually entered into the Every Monday date picker, the 2nd Tuesday picker calculates the 2nd Tuesday based on the date selected in the Every Monday date picker, and the 1st&3rdTuesday date picker is calculated based on the date that gets calculated in the 2nd Tuesday date picker. I'd like to add the possibility of the user manually entering in EITHER the Every Monday or the 1st&3rdTuesday date picker, and calculating the dates either way. I've tried using an IF statement in both the Every Monday and 1st&3rdTuesday date pickers (once with the IF statement in only one date picker and another time with the IF statement in both) and I get a circular reference error. I've also tried adding an OR statement and get an error too. I've also tried modifying the 2nd Tuesday date picker with a nested IF statement and an OR statement to adjust for calculating the date from the EveryMonday date picker and the 1st&3rd Tuesday date picker, and I get an error. Is it possible to accomplish what I need or will I have to find a workaround?

Report
All responses (
Answers (