Hi Paul

You don't provide much detail on how and where this is done, but try
something like
=IF(B1<A1,"expired",B1-A1)

HTH. Best wishes Harald

"Paul Breslin" skrev i melding
.. .
Hello --

I have to keep track of a number of certificates and licenses.
I have a sheet where I have in a column when the license was obtained and
another column when the license expires. There is a third column that
calculates the difference in days between the two.
When the certificate expires I get an out of range error.
Can I capture that error and make the cell simply say: "Expired" ?

Thanks,
Paul