I'm just suggestion that you subtract one date from the other. You could add
your checks like:

=IF(OR(A1="",A2=""),0,a2-a1)





martins wrote:

Tried this but doeasnt seem to work or maybe I'm entering the formula
incorrectly - are you suggesting to substitue part of the formula ar as
an add in? could you clarify the whole formula

Thanks

--
martins
------------------------------------------------------------------------
martins's Profile: http://www.excelforum.com/member.php...o&userid=31616
View this thread: http://www.excelforum.com/showthread...hreadid=526265

--

Dave Peterson