Adding columns for purpose of payment

[Katherine]

HELP PLEASE! I have two cells I want to add to tell me
how many days of service I have to pay. My dilema - is as
below

Cells A B C

03/03/04 03/03/04 0

However the case above I would have to pay for one day of
service

Case two

Cells A B C

03/03/04 03/04/04 1

In this case I have to pay for two days service - the 3rd
and 4th

I would be nice if I could just add one to the formula but
this will not work because if I have no days service one
will still appear --- Please help - anyone have a answer ?

Katherine

 

[Tom Ogilvy]

Same answer as last time you posted:

=if(and(A2="",B2=""),0,B2-A2+1)

 

[Frank Kabel]

Hi Katherine
I provided you a formula solution for this Have you tried it. e.g.
use the following in C1:
=IF(OR(A1="",B1=""),"",B1-A1+1)