Thread: difference between dates
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Clash
 
Posts: n/a
Default difference between dates

Please help,

I am calculating the difference between two dates,
=IF(Q101,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

Reply With QuoteReply With Quote