Existing Item or new one - count items in the last week

[anonnnn]

Hello all,

Im trying to have a column that tells me if my item was already there the week before, or is a new one. Im not being able to do it, maybe someone here can helpme. Thanks!  

In this case, I need that items 1 and 4 has in the Existing column "Y" bc are the one that the previous week were already in the table.

Thanks!!

[anonnnn · Accepted solution]

Just in case anyone can use this in the future. I solved it concatenating two columns, one with the actual date and one with the prior date and use a lookup value.