How do I count a date if it falls between two dates specified in other cells?

Hi, I'm sure my answer is somewhere in these gazillions of threads but I can't find it! I really need to know how to have Excel look at a date (mmddyy) in cell G7and determine if that date, plus one, is more than or equal to the date in B3 and is also less than the date in B4. If the date in G7 meets both criteria, then I need to count that date. Then of course, I need to copy this formula down the page for G8, G9, G10.... The formulas should always refer back to B3 (which is the start date of the current billing cycle) and B4 (which is the last date of the current billing cycle) however. What I'm attempting to do is to count the number of admissions on a bill that occur in the current billing month. G7,G8, G9....are individual admission dates which could be dates from previous months; i.e. I'm doing the June bill and the admission date in G7 is hypothetically 05-31-09. My bill start date is one day after the admission date (hence the "plus one" mentioned previously), so this date should be counted. However, let's say G8's date is 04-03-09. so G8 should not be counted. If G9's date is 06-22-09, it also needs to be counted. Hence, if that was my entire bill, I should have two dates that were counted. Is this a CountIf function? I tried making another column and converted all the admission dates into Julian dates, and made separate cells for the Julian dates for B3 and B4, but still couldn't get a formula to work.

Thanks for any help!

misspen

Does this formula work:

Please Login or Register  to view this content.