Percentage change day-on-day formula

[Tashat]

Hi everyone

I'm having a bit of a brain fry day today. I want to calculate the day-on-day percentage increase/decrease (column C) of the number of activities as shown in column B. Of course I am hitting an issue when it comes to days where there has been zero % change - this is especially true of weekends, where it is very likely that there will be no activities. This is obviously causing me an issue with the formula I have used because you can't divide by 0. Can anyone help me out with a formula/workaround that will enable me to capture the percentage increase / decrease in activity day on day please? I'm using Excel 365. Many thanks in advance.

Operations_MI_Als_team.xlsx
	A	B	C
4	Date	Activities recorded
5	Unit	Count (actual)	%age change DoD
6
7	Source	Daily MI
8	27/10/2020	174	0
9	28/10/2020	197	13.2
10	29/10/2020	320	62.4
11	30/10/2020	163	-49.1
12	31/10/2020	0	-100.0
13	01/11/2020	0	#DIV/0!
14	02/11/2020	346	#DIV/0!
15	03/11/2020	423	22.3
16	04/11/2020	771	82.3
17	05/11/2020	413	-46.4
18	06/11/2020	662	60.3
19	07/11/2020	1	-99.8
20	08/11/2020	0	-100.0
All data - CEM (19Oct>31Dec)

Cell Formulas
Range	Formula
C9:C18,C20	C9	=(B9-B8)/B8*100

 

[GWteB]

Book1
	A	B	C
7	Source	Daily MI
8	27-10-2020	174	0,0
9	28-10-2020	197	13,2
10	29-10-2020	320	62,4
11	30-10-2020	163	-49,1
12	31-10-2020	0	-100,0
13	1-11-2020	0	0,0
14	2-11-2020	346	346,0
15	3-11-2020	423	22,3
16	4-11-2020	771	82,3
17	5-11-2020	413	-46,4
18	6-11-2020	662	60,3
19	7-11-2020	1	-99,8
20	8-11-2020	0	-100,0
Sheet1

Cell Formulas
Range	Formula
C9:C20	C9	=IF(B8=0, B9, (B9-B8)/B8*100)

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
C9:C20	Cell Value	<0	text	NO

 

[Tashat]

Thank you - that's wonderful

 

[GWteB]

You are welcome and thanks for the feedback.