K
Katie
A B C D E F G H
1 - 07/08/04 07/12/04 5 07/12/04 07/30/04 19 23
2 - 05/21/04 05/25/04 5 5
3 - 05/26/04 06/24/04 30 30
4 - -1
5 - 07/14/04 07/26/04 13 07/26/04 07/21/04 1 13
=IF(M7=O7,N(Q7)+N(N7)-1,N(Q7)+N(N7))
Can anyone help - I am using the formula above to
determine the number of days a person in in a Nursing Home
in column a & B -- and number of days in a Skilled Nursing
Facility in E & F - my formula needed to tell if C & E
were same day to not count them twice and if A & B are
same day to count it as one day -- the problem I am having
is in line 4 in above example - if there is no information
for the month - it puts a -1 in column H - I need to have
a 0 if it is blank or I see it as they owe me one day of
costs. Can you tell me how to fix it? I am not good at
computer language -- Thanks so much and have a great
day !!
1 - 07/08/04 07/12/04 5 07/12/04 07/30/04 19 23
2 - 05/21/04 05/25/04 5 5
3 - 05/26/04 06/24/04 30 30
4 - -1
5 - 07/14/04 07/26/04 13 07/26/04 07/21/04 1 13
=IF(M7=O7,N(Q7)+N(N7)-1,N(Q7)+N(N7))
Can anyone help - I am using the formula above to
determine the number of days a person in in a Nursing Home
in column a & B -- and number of days in a Skilled Nursing
Facility in E & F - my formula needed to tell if C & E
were same day to not count them twice and if A & B are
same day to count it as one day -- the problem I am having
is in line 4 in above example - if there is no information
for the month - it puts a -1 in column H - I need to have
a 0 if it is blank or I see it as they owe me one day of
costs. Can you tell me how to fix it? I am not good at
computer language -- Thanks so much and have a great
day !!