Joined

·
1,057 Posts

The second part of the problem is if the month portion of the date is not the same as G2. If it is one month greater, then again look to the day portion, and if it is <=15, set cell H2 equal to "60 Days". If it's >15, set H2 equal to "30 Days".

The same thing if the month portion is two months greater then G2. If day portion is <=15, set H2 equal to "90 Days". If it's >15, set it equal to "60 Days".

The same thing if the month portion is three months greater then G2. If day portion is <=15, set H2 equal to "". If it's >15, set it equal to "90 Days".

If the month portion is less than the number in G2 OR more than 3 months greater, set H2 equal to "".

The purpose of this is to try to separate records into 30/60/90 day buckets based on the date. The complicated part is the stipulation that if they started their training on before the 15th, it moves them up a level. I would appreciate greatly anyone that can solve the problem.