difference between dates

C

Clash

Please help,

I am calculating the difference between two dates
=IF(Q10>1,Q10-E10,"")
but if one of the cells is empty it's showing #VALUE!.

Is there a way to stop this happening.

Many thank
 
D

Daniel CHEN

I used your formula and did not have your problem.
If Q10 is blank, then from your formula, the results is "";
If E10 is blank, then it returns the date value of the date in Q10.
IF both are blank, it also returns "".

If you still have the problem, then try this:
= if(iserror(yourformula), "", yourformula)
replace yourformula in above with IF(Q10>1,Q10-E10,"")

--
Best regards,
---
Yongjun CHEN
=================================
XLDataSoft - Data Analysis Expert, Excel/VBA Specialist
- - - - www.XLDataSoft.com - - - -
Free Excel-Based Data Processing Tool is Available for Download
Free Excel / VBA Training Materials is Available for Download
=================================
 
C

Clash

daddylonglegs said:
Do you have formulas in E10 and Q10?
Click to expand...

Sorry I didn't say.

Yes, they are to formulas, the two dates are pulled thru from two
different spreadsheets.
 
Top