=IF(OR(A1="",A2=""),"",A1-A2+1)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"skchth" wrote in message
...
I am trying to count the days between 2 dates. Start date 01/01/01 and
End
date 01/05/01 should return 5. However the Datediff function will return 4
because it doesn't count the start date. Adding "+1" to the Datediff
function
does not work for me because when the cells with the start and end date
are
empty the cell with the Datediff function must be empty.