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


"Ron Rosenfeld" wrote:

On Tue, 30 Jun 2009 13:57:01 -0700, Mustang
wrote:

Thanks Ron,

I have tried this and tested this also against a date range of 21/5/09 -
29/08/09 and I get the answer of 30.

The missing part for me is where I can tell Excel which billing month I am
in, so if I am billing for August I am looking for the answer of 9 days but
this formula gives me 29 days. Any ideas?

Thanks

I cannot tell from what you write if you are getting a result of 30, or 29 from
my formula???

But from this posting, and your previous postings, your date entry format is
not clear. I had assumed it was a dd/mm/yy format, and also a dd/m/yy format,
but that, applied to your data above, would result in dates of 21 May 2009 to
29 Aug 2009 which, so far as I can see, would result in 29 days in the month of
August (which is what my formula returns). Since you are expecting only 9
days, are you trying to enter dates in a yy/mm/dd format? That would give you
a start date of 9 May 2021 and an end date of 9 Aug 2029 which would result in
9 billable days in August of 2029, but doesn't really make much sense.

So please state unambiguously what the date 21/08/09 means; and also what the
date 21/5/09 means.

So far as I can see, if the date range is 21 May 2009 to 29 Aug 2009, there
should be 29 days in August.
--ron