I'd like to find the increase/decrease between last month's numbers and current month numbers. For example august, had only two tasks but september grew to several. I'd like to see the change in percent if possible.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Calculate month over month change
- Thread starter gwhiz921
- Start date
Toadstool
Well-known Member
- Joined
- Mar 5, 2018
- Messages
- 2,549
- Office Version
- 2016
- Platform
- Windows
Hi GWhiz921,
Is this what you wanted?
Is this what you wanted?
| GWhiz921.xlsx | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | H | I | J | |||
| 1 | Created | Completed | Task | Progress | Aug-21 | Sep-21 | Oct-21 | Nov-21 | Dec-21 | |||
| 2 | 8/18/2021 | 400.00% | 12.50% | 200.00% | 0.00% | |||||||
| 3 | 9/3/2021 | |||||||||||
| 4 | 9/3/2021 | |||||||||||
| 5 | 9/3/2021 | |||||||||||
| 6 | 9/3/2021 | |||||||||||
| 7 | 8/19/2021 | |||||||||||
| 8 | 9/5/2021 | |||||||||||
| 9 | 9/5/2021 | |||||||||||
| 10 | 9/5/2021 | |||||||||||
| 11 | 9/5/2021 | |||||||||||
| 12 | 10/1/2021 | |||||||||||
| 13 | 11/1/2021 | |||||||||||
| 14 | 11/1/2021 | |||||||||||
| 15 | ||||||||||||
Sheet1 | ||||||||||||
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| F1 | F1 | =DATE(YEAR(MIN(A:A)),MONTH(MIN(A:A)),1) |
| G1:J1 | G1 | =EOMONTH(F1,0)+1 |
| F2:J2 | F2 | =IF(F$1<=MIN($A:$A),"",(COUNTIFS($A:$A,">="&F$1,$A:$A,"<="&EOMONTH(F$1,0))/(COUNTIFS($A:$A,">="&DATE(YEAR(EOMONTH(F$1,-1)),MONTH(EOMONTH(F$1,-1)),1),$A:$A,"<="&EOMONTH(F$1,-1))))) |
Upvote
0
