# count new entries from dates

#### RodrigoFinguer

##### Board Regular
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.

### Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.
L

#### Legacy 436357

##### Guest
Hi,

Without knowing the details maybe you can adapt this for your range:

=countif(a1:a10,"="&today())

#### RodrigoFinguer

##### Board Regular
Hi,

Without knowing the details maybe you can adapt this for your range:

=countif(a1:a10,"="&today())

Look at this:

https://imgur.com/a/e9aOzHv

I need a formula to count the blue values in the "N" column. A formula to count how many values are new at day 24/01 that weren't at 23/01.

#### Fluff

##### MrExcel MVP, Moderator

Excel 2013/2016
MNOPQ
2Serial No.Date
37085923/01/201924/01/20194
48473223/01/2019
56340323/01/2019
67570523/01/2019
75528723/01/2019
88954223/01/2019
96963623/01/2019
107085924/01/2019
118473224/01/2019
126340324/01/2019
138867624/01/2019
147536724/01/2019
157085024/01/2019
167703024/01/2019
Key
Cell Formulas
RangeFormula
Q3=SUMPRODUCT(--(COUNTIF(M3:M16,M3:M16)=1)*(N3:N16=P3))

#### RodrigoFinguer

##### Board Regular
What does the "--" means?

Last edited by a moderator:

#### Fluff

##### MrExcel MVP, Moderator
It converts True/False values to 1 or 0, but it doesn't need to be there on this occasion.

Also please do not quote entire posts as it just clutters up the board.

#### RodrigoFinguer

##### Board Regular
It converts True/False values to 1 or 0, but it doesn't need to be there on this occasion.

Also please do not quote entire posts as it just clutters up the board.

Ah okay, i'm sorry.
It worked, but there is a way to calculate the new values comparing to yesterday? Your formula calculates the new values without comparison.

#### Fluff

##### MrExcel MVP, Moderator
What would you expect the outcome to be with the data in post#4?

#### RodrigoFinguer

##### Board Regular
What would you expect the outcome to be with the data in post#4 ?

The result is correct in post #4 , but in my worksheet there is data from 02/01/2019 to today. Applying your formula, returns the values that weren't NEVER in my sheet but today, but I actually need the values that weren't just the last worked day, that was friday. So, a comparison between yesterday(or friday in this case) and today, showing me the new values from friday to today. I don't know if i was clear.

#### RodrigoFinguer

##### Board Regular
Excel 2013/2016
MNOPQ
2Serial No.Date
37085922/01/201924/01/20196
48473222/01/2019
56340322/01/2019
67570522/01/2019
75528723/01/2019
88954223/01/2019
96963623/01/2019
107035223/01/2019
117085924/01/2019
128473224/01/2019
138867624/01/2019
147536724/01/2019
157085024/01/2019
167703024/01/2019

<tbody>
</tbody>

Like this... My outcome is 6 because none of these values in day 24/01 are in 23/01, but it can still be in older days, like 22/01

Replies
4
Views
273
Replies
4
Views
236
Replies
8
Views
339
Replies
0
Views
392
Replies
1
Views
178

1,195,664
Messages
6,011,019
Members
441,579
Latest member
satishrazdhan

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Which adblocker are you using?

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back