Thread: DateDIF
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Paul Breslin Paul Breslin is offline
external usenet poster
 
Posts: 10
Default DateDIF

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