As an example in cell C10:
=IF(B10<DATE(2000,1,1),DATE(2001,1,1),B10)

"Jose Martinez" wrote:

I want to find all the dates from a list that are earlier than a specific
date and replace them with another date. How do I do that without having to
do one by one?