I have a report that has a 2-week parameter date range. Say start 6/16/13 to 6/29/13
I need to have a formula for Week 1 (6/16/13 - 6/22/13) and Week 2 (6/23/13 - 6/29/13)
What's the best practice to accomplish this task? Using DateAdd for a formula? Or some other date function? I'm probably going to put the results in a group footer or in the details section.
Thanks in advance.