Re: DateDIF

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" <pbreslin@xxxxxxxxxxxxx> skrev i melding
news:uPWqf.17565$kP5.1220@xxxxxxxxxxxxxxxxxxxxxxxxx
> Hello --
>
> I have to keep track of a number of certificates and licenses.
> I have a *** 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
>
>


.