To build on Spiky's formula:

=IF(TODAY()-C2<2922,"Not eligible prior to "&C2+(365.25*8)
,TEXT((27393.75+B2+C2)/2,"mm/dd/yyyy"))

"BAD" wrote:

Thanks Spiky. I tested with your formula but I got the "not eligible" text
in my field. Which is correct but I want the formula to tell me the date I
will be eligible.

"Spiky" wrote:

The simple answer is just wrap an IF around it. 8 years should be 2922
days, and I hope I grabbed the proper formula from this discussion, I
haven't tested it completely:

=IF(TODAY()-C2<2922,"Not Eligible",TEXT((27393.75+B2+C2)/2,"mm/dd/
yyyy"))

But for all the "another eligible company" parts, it gets more
complex. You'd have to have that data somewhere in the worksheet to
reference. No doubt it can be done, if those other dates are there.
So...what do you have?