Please edit your question, not add a fake answer that is more questions.
I don't see how that changes my response. Why do you need to add days in SQL and not in your code that calls the stored proc ? According to MSDN, in SQL Server the + operator can be used to add days. Using google, it also took me 3 seconds to find
this[
^]. However, I still don't see why you need to complicate your proc and not generate your date range in your code.