Hi all.

Was going over my spreadsheet and was missing a customer who stayed with us starting 1/31 until today. My calculation was off by one for people who Checked In during the month of January. What I am seeing is that the formula does not count the first day and tally's the rest. For our purposes, the first day should be counted and the check out date is not. This is the formula used to add up days stayed within a search string:

=MAX(0,(MIN(Intakes!$G$17,N13)-Intakes!$F$17)-(MAX(M13,Intakes!$F$17)-Intakes!$F$17)-(EOMONTH(M13,0)>EOMONTH(Intakes!$G$17,0))+(EOMONTH(M13,0)<EOMONTH(Intakes!$F$17,0)))

F17 is the admit date and G17 is the discharge date.

Any ideas?

Thanks