If you're just counting the days between dates:

=a1-a2

(but format it as a number or general.)

martins wrote:

I use the following formula to calculate the days between dates and to
return zero when dates are the same –

=IF(OR(A1="",A2=""),0,DATEDIF(A1,A2, "d"))
How would I also allow for the eventuality where the date in cell A2 is
earlier than A1 and where the result would then be a minus figure ?

At present the formula returns a "Num" error when this happens

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