I thought I had posted a reply yesterday, but I don't see it here, so I will repost, just in case.

No, I need more than just a simple formula that counts up the # of different patient account #'s. The # of admits is one of the main key indicators that hospitals have to report, so it is important that we count the baby in the correct month, and only once, for the whole stay. Here are a few scenarios that will hopefully help explain better.

Scenario 1:
Baby born 12/29/13 - went into NICU right away
Admit will be counted for 12/29/13
Baby still in NICU through 1/20/14.
In January I would not count an admit on the baby, since they STARTED in the NICU in December.

Scenario 2:
Baby admitted 12/29/13 - to a regular room
Baby became ill and had to go into NICU on 1/2/14
Baby in NICU through 1/10/14.
I would need to count this baby as an admit on 1/2/14, since that is when they came into the NICU. Normal (non-sick) babies do not get counted, so since baby was in a normal room with the mother, it wasn't counted in December. We would only count the baby once it got admitted into the NICU.

Does this help?