The add one will not work because it will add one to those
persons who have no payment coming - I have to have a way
to identify that the one is added only to those that have
earned payment --

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

or use OR as Frank suggested:

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



--
Regards,
Tom Ogilvy


"Katherine" wrote in message
...
The add one will not work because it will add one to those
persons who have no payment coming - I have to have a way
to identify that the one is added only to those that have
earned payment --

Hi Tom
you don't give up, do you :-))

@Katherine: If these functions do not work for you please provide an
example of your data, stae what our functions have returned and what
your expected result would be. I think Tom + I agree that either of
these formulas should work

--
Regards
Frank Kabel
Frankfurt, Germany

"Tom Ogilvy" schrieb im Newsbeitrag
...


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

or use OR as Frank suggested:

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



--
Regards,
Tom Ogilvy


"Katherine" wrote in message
...
The add one will not work because it will add one to those
persons who have no payment coming - I have to have a way
to identify that the one is added only to those that have
earned payment --