Greetings,

Looking for a formula that will count new hires, based on one year earlier from today's date.

In column E, I have the date that people were hired. For example, 10/12/11.

In column F, I would like an "x" to appear if that date is less than one year from today.

If the date rolls over to more than one year, I would like the "x" to disappear.

Thanks!