DateDIF
- From: "Paul Breslin" <pbreslin@xxxxxxxxxxxxx>
- Date: Fri, 23 Dec 2005 17:55:05 -0000
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
.
- Follow-Ups:
- Re: DateDIF
- From: Harald Staff
- Re: DateDIF
- Prev by Date: Re: Macro to move info and delete duplicat records
- Next by Date: Re: Workbook and Window object question
- Previous by thread: Re: spliting out data in one field into two
- Next by thread: Re: DateDIF
- Index(es):