Hi, I am trying to count the first 30 days of people's stays during FY11-12 (7/1/2011 - 6/30/2012).
I have two columns: Entry Date and Exit Date, and they are from dates that span over the past four years. I basically need a formula that will count only the days within the fiscal year above AND it has to be during the first 30 days of their total stay. I'm running into trouble with stays that start in June 2011 and end in July 2012.

I appreciate all help, thanks.

EK