Sorry for the delay in getting back to you - things have been crazy busy at work.

The patient # IS in column B, and all of these patients are the babies #, not the mom's #. Column C is NOT NECESSARILY the day they entered the NICU - that would be column J the first time that account # appeared. It is possible that baby was admitted into the mom's room, on the day of birth, but 2 days later took a turn for the worse. In that case, the admit date would be, for example, 2/22/14, but the first day they came to the NICU was 2/24/14, which would be what shows up in column J. Now, if they are still in the NICU on 2/25/14, column C would still say 2/22/14, and column J would now say 2/25/14. Basically, column J just shows every date of service that they spent in the NICU.

As far as the desired output: We are going to keep up with this spreadsheet on a daily basis - loading the new babies that entered the NICU on the previous day. Our CEO would like to see, probably by month, the # of babies for each year (2013 & 2014), with a variance column. It would also be nice to see what the average length of stay would be. (We would have to count the # of times the babies account # appeared). If a baby is in the NICU for more than a month, and if we are reporting on January, we would only count up January's days in the January comparison, and then the February dates of service in the February comparison. Does that makes sense? The other thing that we have to report is how many admits we had in a particular month. If the patient was admitted to the NICU in January, but we are reporting on February, we would NOT count the admit in February, since we are only allowed to count an admit once for their hospital stay. I had originally thought I could say if(C=J,1,""), but since there are times that baby stays in mom's room the first day, it would never count that baby as an admit to the NICU. I'm not sure how we can capture those types of babies.

Did I clear things up, or do you still have questions? Thank you for your help!