A complex but fun Calendar Offset solution to a difficult and high-error statutory document issue
- Installations and Emergencies!
- The Learning Curve, Three Training Courses
- Deep Dives on Specific Features
- The Community Treasure Chest
- Word Warriors®
- Resource Library
- News and Updates
A statute requires a date that is the Friday following the first Tuesday of a month, which Tuesday is at least 90 days but no more than 120 days in the future. The manual error rate was horrendous and the time spent on the initial computation and the follow-on proofing burned enormous wasted time. Our programs take 1.5 seconds to reach 100% accuracy. Here's how.
Remember that Derived Answers are best hidden from form Users, done by clicking Row/Column>Show/Hide.
tags: calendar, complex, offset, Friday, Tuesday, TTEE