How to clear cell contents in a certain column based on set criteria

Hello,

I am trying to clear the contents of a cell in a column.

I need the macro to search column N, the number of rows will vary each time and I need it to search all of column N.
for each row in column N, if the cell = "01/01/1900" then I need it to delete the date. If it has another date, leave the other date.

Thanks so much. I ended up chaning my date format to look for "1900/01/01" and then it worked. Thank you so much for the help! This is going to save a lot of time.