Thank you for reply. I did make it function by entering zeros in blank cell.
This gave a date function. Will keep your formula for future reference thanks
again


"daddylonglegs" wrote:


Hi Curt,

If you want the difference in days between two dates you can use just

=B1-A1

format as general

although to eliminate errors possibly

=IF(A1*B1,IF(A1<B1,B1-A1,""),"")


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=527355