Counting number of times the same entry has been entered in the previous 7 days.

John74Racing 

You can use an IF statement, as @mtarler showed, or you could alter the format (my preference). Why? It's about downstream calculations. While a simple =SomeCell will treat "" as a zero, as well as =SUM(SomeCell), my preference is to have an actual zero value if that fields purpose is numerical. If I don't want to show the zero value, I'll adjust the format accordingly. It can get tricky, but cell formatting (i.e. Custom) works like this:

Greate than zero; Less than zero; Equal to zero; Text

So if you look at the Comma style format, it looks like this:

_(* #,##0.00_);_(* (#,##0.00);_(* "-"??_);_(@_)

You'll notice each part separated by a semi-colon, along with some special characters which represents how you want to show your numbers. If you leave that section blank, nothing is shown for the format, although the value still resides in the cell.

A fun trick to play on co-workers is to format the cell like: ;;;

This will not show any values. Muwahaha! Don't tell them I told you that lol.

Some great formatting resources:

https://exceljet.net/custom-number-formats

https://www.exceltactics.com/definitive-guide-custom-number-formats-excel/