determinedtoexceed
New Member
- Joined
- Aug 20, 2019
- Messages
- 38
Dear Sirs
Is there a way for excel functions or VBA to automatically target "the 7 dates of last week" and calculate the 7 days average , and taking this data to shown on for example cell AAA9?
[/QUOTE]
Is there a way for excel functions or VBA to automatically target "the 7 dates of last week" and calculate the 7 days average , and taking this data to shown on for example cell AAA9?
Book1 | ||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | |||
1 | ||||||||||||||||||||||||||
2 | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | ||||||
3 | Item | 2019/11/18 | 2019/11/19 | 2019/11/20 | 2019/11/21 | 2019/11/22 | 2019/11/23 | 2019/11/24 | 2019/11/25 | 2019/11/26 | 2019/11/27 | 2019/11/28 | 2019/11/29 | 2019/11/30 | Nov. FCST | Nov. Actual vs FCST | Nov. sales order issued | 2019/12/1 | 2019/12/2 | 2019/12/3 | 2019/12/4 | 2019/12/5 | 2019/12/6 | 2019/12/7 | ||
4 | 0006TW | -816 | -641 | -524 | -714 | -611 | -68 | 0 | -962 | -816 | -642 | -666 | -855 | -923 | 16360 | 102.74% | -16808 | -8 | -1062 | -1370 | ||||||
5 | 0036TW | -486 | -452 | -325 | -362 | -358 | -56 | -1 | -549 | -502 | -424 | -465 | -450 | -609 | 8601 | 129.39% | -11129 | -723 | -1080 | |||||||
6 | 0049TW | -188 | -141 | -125 | -132 | -147 | -17 | 0 | -175 | -199 | -161 | -134 | -170 | -206 | 3152 | 114.28% | -3602 | -194 | -330 | |||||||
Sheet1 |
[/QUOTE]