I must have typed something wrong. I went back and copied and pasted the formula instead, and I did get 244 now. I'm wondering if I needed to provide the # of admits by month though, how can I have it only count January admits, as an example. instead of the whole year. What would really be helpful is if there was a formula that we could use, (in an admit column) that would show a 1 on the patient, and what day they would have been considered an admit. The reason this would be better is because if we are only showing 244, I can't easily show which patients make up those 244 admits. Since we are going to be doing comparisons between both years, and the different months, chances are there will be times when I have to show which patients are being counted as admits. Would this be possible to have a # populate on the day that we count the admit?