Hi Pandora,

I think this works

=IF(AND(B2="",C2="",A2=""),"",IF((AND(B2="",C2="", A2<"")),TODAY()-A2+1,IF(AND(A2<"",C2<"",B2=""),C2-A2+1,IF(AND(A2<"",B2<"",C2=""),B2-A2+1,IF(AND(A2<"",B2<"",C2<""),C2-A2+1)))))

It's basically nested If statements that read that comes back with a
true or flase statement e,g

To help you read it examine what the first part is doing

IF(AND(B2="",C2="",A2=""),"",

It checks to see if A2, B2 and C2 are all blank, If they are it comes
back blank and so

Hope this helps

VBA Noob


--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=552944