View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
 
Posts: 3,885
Default Adding columns for purpose of payment

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)


--
Regards
Frank Kabel
Frankfurt, Germany

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