johnnymotown
New Member
- Joined
- Apr 24, 2014
- Messages
- 4
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.
=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.