Hello
I am wondering if someone can help
I have a sheet with information set as below
A B C D E
1 AAAA 13/3/2013 rrrrr 0.5 3
2 BBBB 27/3/2013 nnnn 0.7 4
3 ccccc 28/3/2013 llllll 0.5 2
4 dddd 15/04/2013 zzzz 1 3
What I am looking for is something that will take todays date +7days and give me totals for columns D+E.
I have tried using Vlookup (today()+7 but unsure of what follows as I am only getting one value
Thanks
I am wondering if someone can help
I have a sheet with information set as below
A B C D E
1 AAAA 13/3/2013 rrrrr 0.5 3
2 BBBB 27/3/2013 nnnn 0.7 4
3 ccccc 28/3/2013 llllll 0.5 2
4 dddd 15/04/2013 zzzz 1 3
What I am looking for is something that will take todays date +7days and give me totals for columns D+E.
I have tried using Vlookup (today()+7 but unsure of what follows as I am only getting one value
Thanks