Formulas and making info invisible
 

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

Formulas and making info invisible
 

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

--
Regards
Frank Kabel
Frankfurt, Germany

"Katherine" schrieb im Newsbeitrag
...
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

Formulas and making info invisible -
 

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


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

--
Regards
Frank Kabel
Frankfurt, Germany

"Katherine" schrieb im
Newsbeitrag
...
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

.

Formulas and making info invisible -
 

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

--
Regards,
Tom Ogilvy

"Katherine" wrote in message
...
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


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

--
Regards
Frank Kabel
Frankfurt, Germany

"Katherine" schrieb im
Newsbeitrag
...
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

.

Formulas and making info invisible -
 

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

--
Regards
Frank Kabel
Frankfurt, Germany

"Katherine" schrieb im Newsbeitrag
...
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


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

--
Regards
Frank Kabel
Frankfurt, Germany

"Katherine" schrieb im
Newsbeitrag
...
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

.