Formulas and making info invisible

[Katherine]

I have created a data base where I am substracting dates
for payment purposes - if there are any services on any
day a full 24 hour day has to be paid for - but when I
subtract the dates and put in for example 03/03/04 -
03/03/04 - instead of getting one day I get 0 -- I tried
adding 1 to the formulat but came up with a more serious
problem - those people I don't have to pay and should have
a 0 now have a one - can you help me - HELP PLEASE - is
there a way to program excell to understand? Katherine

 

[Frank Kabel]

Hi
how do you identify the people you don't have to pay?

 

[Katherine]

Frank -
\Frank
I have it set up as follows

Column A Columm B Column C

03/03/04 03/03/04 0

blank blank 0

if I add one to my formula - I get

blank blank 1

and I might end up paying someone I shouldn't


right now this is how it reads
if I have to date it also reads 0 so I know I pay nothing

but Column C isn't correct because I have to pay for one
day of service - the day of 03/03/04

any suggestions

thank you in advance

Katherine

 

[Tom Ogilvy]

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

 

[Frank Kabel]

Hi
try the following in C1:
=IF(OR(A1="",B1=""),0,B1-A1+1)