Is there a way to negate #NUM! from being displayed when formula refers to an empty cell?

[johnnymotown]

I have the following formula that calculates the number of days between two dates.

=DATEDIF(R3,S3,"D")

R3 is "Date Listed"
S3 is "Date Sold"

However, I don't enter the "Date Sold" until the item is sold obviously. The problem is, I don't want my sheet littered with #NUM! until I enter a date into "Date Sold".

Is there a way to negate that (#NUM!) text from being displayed? Is there a way to write into the formula that if "S3" is blank that nothing is displayed in the field?

Thank you in advance for your help.

 

[mfexcel]

Try:
=IF(S3="","",DATEDIF(R3,S3,"D"))
or using IFERROR
Check this out:
How to get rid of the error message? | wmfexcel

I have the following formula that calculates the number of days between two dates.

=DATEDIF(R3,S3,"D")

R3 is "Date Listed"
S3 is "Date Sold"

However, I don't enter the "Date Sold" until the item is sold obviously. The problem is, I don't want my sheet littered with #NUM! until I enter a date into "Date Sold".

Is there a way to negate that (#NUM!) text from being displayed? Is there a way to write into the formula that if "S3" is blank that nothing is displayed in the field?

Thank you in advance for your help.

 

[Marcelo Branco]

Try

=IF(COUNT(R3:S3)=2,DATEDIF(R3,S3,"D"),"")

M.

 

[johnnymotown]

I'm trying to use the ISERROR function and came up with this:

=IF(ISERROR(DATEDIF(R3,S3,"D"))," ",DATEDIF(R3,S3,"D”))

But it's not working.

Try:
=IF(S3="","",DATEDIF(R3,S3,"D"))
or using IFERROR
Check this out:
How to get rid of the error message? | wmfexcel

 

[mfexcel]

I tried that and had no problem.
Are you sure the date input in R3 and S3 are values (formatted as Date), not text?

I'm trying to use the ISERROR function and came up with this:

=IF(ISERROR(DATEDIF(R3,S3,"D"))," ",DATEDIF(R3,S3,"D”))

But it's not working.

 

[Peter_SSs]

What about just

=IF(S3="","",S3-R3)

 

[mfexcel]

Totally agree that we only "D" is needed, R3-S3 is the most direct way.

What about just

=IF(S3="","",S3-R3)