You could use EOMONTH and DAY to get the 28-31 number desired.

scott wrote:

I am working on a spreadsheet that has monthly data for a five-year period. I
need to convert all the data for each month into daily data. I am simply
dividing the total for each month by the number of days in each respective
month..Instead of copy and paste, or drag and drop, is there a formula that
allows a user to click on a cell containing the name of a month and have
excel recognize the number of days in that month? For example, if A1 has
"September" and B1 has 1,000,000, can I insert a formula in C1 that allows me
to do =B1/A1 instead of B1/30?

Sorry for the confusion and thanks for the help.