Why not just subtract the expiry dates from today's date? With the date in
D2, use

=today()-D2

Format the cell as general



"Steve" wrote:

Is it possible to display the result of a negative DATEDIF function? I
am checking a column of warranty expiration dates against the current
date, and displaying that in an adjacent column. When the item is past
its expiration it shows the #NUM! error. How would I format this to
show the number of days past its expiration?