Countif New Entries

[Legacy 436357]

Hello,

I have values in column A and dates in column B. How can I count the new entries today? What I mean is count the ones that occur today that haven't been entered before.

Thank you for your help,
XJ

 

[jimrward]

A search on google for excel countif today yields plenty of examples to get you going

 

[Legacy 436357]

Thanks but I haven't found any that apply

 

[Legacy 436357]

I tried this but it doesn't work:

Excel Workbook
	A	B	C	D	E
1				Start Date	23/01/2019
2	Serial N.	Date		End Date	24/01/2019
3	70589	23/01/2019
4	84732	23/01/2019			#REF !
5	63403	23/01/2019
6	75705	23/01/2019
7	55287	23/01/2019
8	89542	23/01/2019
9	69636	23/01/2019
10	70859	24/01/2019
11	84732	24/01/2019
12	63403	24/01/2019
13	88676	24/01/2019
14	75367	24/01/2019
15	70850	24/01/2019
16	77030	24/01/2019
Sheet1

 

[jtakw]

Why are you duplicating someone else's thread?

https://www.mrexcel.com/forum/excel-questions/1085048-count-new-entries-dates.html

 

[Legacy 436357]

I was trying to help. Perhaps asking in a different way. Sorry

 

[Fluff]

@xjohnson
Whilst I appreciate that you were trying to get help for someone else, please do not duplicate threads.