How to pull month from another column and then apply the number of days in that month

I guess this might be an IF statement formula? I copy data from a state database regularly and dump it into Excel. The date column (Column A) pastes as, for instance, 5/1/2011 or 11/1/2011. (There is one row for each month of data.) I would like to create another column, Column I, that looks at Column H and then divide whatever is in Column H by... whatever is in that same ROW, in Column A, and pull the month, such as "5" and have it recognize it as the month of May and then can it "know" that May has 31 days... and so, at that point I would need to divide by 31*1000.

How could I do this? Would it be 12 IF statements? I am not an expert in how to compose formulas.

Not sure I follow the whole chain of events you want to accomplish.
Particularly the dividing part...

But this will give you the # of days in the month of a given date.
Say A1 is 5/1/2011

=DAY(EOMONTH(A1,0))

Awesome, that makes it simple, lol. I easily made a formula with that.

You're welcome.