I got an application where I register admissions and discharge for a small
clinic I work
This application is set up to print a census at midnight every night. So far
this is
not problem, is reliable with tru numbers. After having some printer
problems and
loosing some midnight census I did a excel worsheet where every admission and
discharge is register with dates.
A B C
NAME ADM. DATE DISC. DATE

1

2

Column D =COUNTIF(B1:B2170,"1/01/2009") and copy down changing the date in
order to count how many admissions each date ( "1/02/2009", "1/03/2009",etc.)
Column E =COUNTIF(C1:C2170,"1/01/2009") and copy down... to know how many
discharges each day.
F will be the column that does not macth with the midnight census.
F= the previous day census+admissions-discharges.
Let's say F1=28
F2=F1+D2
Will give me the counting of admissions and
discharges(actual census) for 1/1/2009
F3=F2+D3-E3
Will give me the counting admissions and discharges(actual census) for
1/2/2009
Problem:
Column F does not macth the midnight print out previoussly done and is not
reliable for future calculations.
Is this a reference error, Xl error or Data error?
Differences are by 1 or 2 between midnight census and Column F in XL.
Thanks for your expertise.