Hi all,
I am working on a work project and we are trying to automate it as much as possible. So I came across this major problem.
I have raw date with the date and number of applications submitted on each day. I used pivot table to count the number of applications by each day. It looks like this.
date application
1/1/13 -- 2
1/2/13 -- 3
2/5/13 -- 5
Grand Total -- 10
Now I want to calculate the number of applications within the week (back 7 days from today). I have tried different formulas but nothing makes sense to me. Can you guys help me out?
Thanks.
Bookmarks