Thanks Fluff, so I misunderstood the question.
[TABLE="width: 85%"]
<tbody>[TR]
[TD]
Worksheet Formulas[TABLE="width: 100%"]
<tbody>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]
[TH]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]Q3[/TH]
[TD="align: left"]=SUMPRODUCT(
--(COUNTIF(M3:M16,M3:M16)=1)*(N3:N16<>P3-1))[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
EDIT: think I may still be confused...
It didn't worked... when i used big data the value returned was ALL new values EXCEPT the last day using your formula, so, since I have values from 2nd january it counts ALL new values.
This is how i am doing right now using pivot table:
[TABLE="class: grid, width: 85%"]
<tbody>[TR]
[TD="align: center"]
Cell[/TD]
[TD="align: center"]
A[/TD]
[TD="align: center"]
B[/TD]
[TD="align: center"]
C[/TD]
[TD="align: center"]
D[/TD]
[TD="align: center"]
E[/TD]
[TD="align: center"]
F[/TD]
[TD="align: center"]
G[/TD]
[TD="align: center"]
H[/TD]
[/TR]
[TR]
[TD="align: center"]
1[/TD]
[TD]Serial N.[/TD]
[TD]22/01/2019[/TD]
[TD]23/01/2019[/TD]
[TD]24/01/2019[/TD]
[TD]25/01/2019[/TD]
[TD]26/01/2019[/TD]
[TD]New Values (day 25/01)[/TD]
[TD]New Values (day 26/01)[/TD]
[/TR]
[TR]
[TD="align: center"]
2[/TD]
[TD]101784[/TD]
[TD]1[/TD]
[TD][/TD]
[TD]1[/TD]
[TD][/TD]
[TD]1[/TD]
[TD][/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD="align: center"]
3[/TD]
[TD]102756[/TD]
[TD][/TD]
[TD]1[/TD]
[TD][/TD]
[TD]1[/TD]
[TD][/TD]
[TD]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: center"]
4[/TD]
[TD]243576[/TD]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]1[/TD]
[TD][/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD="align: center"]
5[/TD]
[TD]875233[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: center"]
6[/TD]
[TD]542113[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: center"]
7[/TD]
[TD]697645[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD][/TD]
[TD]1[/TD]
[TD][/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD="align: center"]
8[/TD]
[TD]226544[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[TD]1[/TD]
[TD][/TD]
[TD]1[/TD]
[/TR]
</tbody>[/TABLE]
I use pivot table, using counting of serial numbers by date, and at the end i just do as follows:
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Formula G2 (or any of this column)[/TD]
[TD][TABLE="width: 500"]
<tbody>[TR]
[TD]Formula H2 (or any of this column)[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]=if(and(E2=1;D2="");1;0)[/TD]
[TD]=if(and(F2=1;E2="");1;0)[/TD]
[/TR]
</tbody>[/TABLE]
This way i can do a graph per day showing how many values i had new, per day, just summing columns G and H.
Obs: sorry for my bad table, i don't know how to customize. Sorry also for my english, I am not fluent.