count new entries from dates

[RodrigoFinguer]

Hi guys, i really need this. I am thinking about more than a month but i can't get it!

I have values (serial numbers) in different dates, i will send a picture for better understanding.

I need to calculate the serial numbers which is new, the values that weren't yesterday in my sheet but it is today. I just know how to do it using dynamic table... there is a way to do it with formulas? Thank you so much!!

In my image, the green values are the same in both days and the blue ones are the new values.

 

[jtakw]

Glad it worked for you.

I don't understand your latest question above, can you give a few samples with expected results and explanation ?

 

[RodrigoFinguer]

Glad it worked for you.

I don't understand your latest question above, can you give a few samples with expected results and explanation ?

That's alright, I managed to do using what you've done.
Thank you so much!!

 

[jtakw]

Glad you sorted it out, you're welcome.