On Tue, 30 Jun 2009 16:51:01 -0700, Mustang
wrote:

Sorry I mistyped the dates. My date range is 21/5/09 - 29/08/09

I tested it for June (month 6) and got an answer of 30, which is correct for
how we bill.

Thanks

Well, then I don't understand how you got a result of 29 for the month of
August.


So as not to have to deal with typos, please post the exact formula you used.

Don't TYPE it into your response. Rather select the formula in the Excel
formula bar; then copy it and paste it into your response.

Please do the same with your start-date and end-date data.

I do get a result of 9 when using the dates you provide above,

Start Date End Date
21-May-2009 09-Aug-2009


and testing for the month of August.
--ron