Check if data is new or data is existing from yesterday

[overclocked]

Hi, i am working on a project, and i need to check if ID is a new entry for today or if ID is exists is from yesterday. Below is my sample data

ID	Date	Qty
AA001	4/6/2020	1500
AA002	4/6/2020	900
AB003	4/6/2020	2300
AA01	4/7/2020	1500
AB003	4/7/2020	2300
AC007	4/6/2020	500
AD023	4/7/2020	3000

Hope someone can answer this. Thank you!

[Yakushi]

Hello,

How about something like if(Date=Today(),'Today','Yesterday') ?

Regards