Read all -- Adding columns for paying

[Katherine]

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 --

 

[Tom Ogilvy]

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

or use OR as Frank suggested:

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

 

[Frank Kabel]

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