What's new

Quick Basic Excel Question (1 Viewer)

Vince Maskeeper

Senior HTF Member
Joined
Jan 18, 1999
Messages
6,500
This is real basic, I'm sure, but I'm not a very active excel user:

I have a date field (When a warranty expires), and then a field telling me how many days until that date.

In some cases, the date is in the past- i.e. the Warranty is already expired. In which case, I get a #NUM! error- because I'm trying to subtract and getting negative days. I just want to add to my function a condition that will trap out the #NUM! error and display the text EXPIRED when it gets that error.

I tried dabbling with tacking on an IF to my function, but it doesn't work. The formula to get the number of days is:

=DATEDIF(NOW(),N2,"d")

Wondered what I can tack on to make an IF("#NUM!","EXPIRED") type function work?

-Vince
 

Ted Lee

Senior HTF Member
Joined
May 8, 2001
Messages
8,390
shoot vince...by reading your title, i thought you were going to ask how to sort a column or something. :)
 

Users who are viewing this thread

Forum Sponsors

Forum statistics

Threads
349,121
Messages
4,869,042
Members
142,484
Latest member
pox;and
Recent bookmarks
0
Top