Count # of cells greater than x

I maintain a list of projects for my office. I'd like to create a formula where when the value of one cell is greater than a certain date Excel will place a "1" in another cell so I can count up the number.
For example I need to count the number of projects which were completed within 5 years (and sometimes 10 years).

I've been doing it by hand, but it can be tedious. Can anyone help?

Hello and welcome to the forum.

I recommend uploading a small representative sample of your data along with the desired results (which you can enter manually) based on that data.

To upload an Excel workbook, follow these steps:
1) Click on "Go Advanced"
2) Click on "Manage Attachments"
3) Click on "Choose File"
4) Choose your file and click on "Open"
5) Click on "Upload"
6) Click on "Close this window"

example hopefully the attachment will show up.