I use the following formula to calculate the days between 2 dates –

=if(or(A1="",B1=""),0,B1-A1

How would the formula look if I wanted to add another column say ‘C1’ –
and then for the result to be calculated according to which cell had a
date entry e.g. either B1 or C1 - that would then minus A1?


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