What are N1...N7? Are they the number of days to add to a date?

Maybe this article will help... should be required reading.

Forum Etiquette: How to post data/code on a forum to get the best help[/url]

Could you post CREATE TABLE and INSERT scripts so we can see what you're working with? Pictures are pretty, but they don't paste into SSMS really well...