difference between dates

[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 thanks

[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
=================================
"Clash" <[email protected]> wrote in
message news:[email protected]...
>
> 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 thanks
>
>
> --
> Clash
> ------------------------------------------------------------------------
> Clash's Profile:
> http://www.excelforum.com/member.php...o&userid=18951
> View this thread: http://www.excelforum.com/showthread...hreadid=545642
>

[[email protected]]

Hope this helps:

=IF(AND(ISNUMBER(Q10),ISNUMBER(E10),Q10>1),Q10-E10,"")

ed

[daddylonglegs]

Do you have formulas in E10 and Q10?

[Clash]

Do you have formulas in E10 and Q10?

Sorry I didn't say.

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


I have just used Ed's formula and it cleared up the problem, brilliantly.

Many thanks everyone.
Your help was invaluble, as always.