Thanks for the clarification. I think I have just what you need below. @melissa and I worked out two different solutions to this issue with another member last month. Both approaches provided will do I think exactly what you need, but hers wins on style points with a very cool use of the DATEADD function to solve this problem.