Date Range Help
Posted by Kevin Merlo on January 21, 2002 5:18 PM
We perform scheduled maintenance intervals 92 days apart. They are called 92, 184, 368 inspections, with the higher inspection being more extensive and covering the requirements of the lesser inspection. Here's the dates when the next inspections are due, in order: (92) 4-6-02, (184) 7-7-02, (368)6-19-02. I know MIN will give me 4-6-02 but I actually need to work the 368, because the time between 4-6-02 and 6-19-02 is less than 92 days. My brain hurts trying to figure out how to make Excel do this calculation for me. I promise to name my next kid after the person that can give me the answer!!!!!