DateDIFF

[Paul Breslin]

Hello -

I have a spreadsheet where I store the names and expiration dates of a
number of documents.
I have a cell where I place a NOW()
In a column next to the expiration date of each document I have placed a
DateDIF which checks the interval between NOW() and the date of the
document's expiration and returns the number of days until the document
expires.
Here, the current date (NOW()) is stored in cell C1, the document expiration
date resides in E63, and the interval is days D. Like this:
=DATEDIF($C$1,$E$63, "D")
This works fine until the document has actually expired and then I get a
#NUM! error.
I would like some code to change this #NUM! to 'EXPIRED'

Thanks,
Paul

 

[Chip Pearson]

Paul,

Try

=IF(ISERROR(DATEDIF($C$1,$E$63,"D")),"EXPIRED",DATEDIF($C$1,$E$63,"D"))


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com