last day of month

Hi

I am using a formula to get a sum amounts between the first of the month and
the last day of the month. I am using 29 as the last day of the month.
months run from August to April.

=SUMIF(G$5:G$32,"="&DATE(YEAR($A34),MONTH($A34),1 ),H$5:H$32)-SUMIF(G$5:G$32
,""&DATE(YEAR($A34),MONTH($A34),29),H$5:H$32)

TIA

Radeesh

On Wed, 17 Sep 2003 14:48:38 +0530, "Radeesh" wrote:

Hi

I am using a formula to get a sum amounts between the first of the month and
the last day of the month. I am using 29 as the last day of the month.
months run from August to April.

=SUMIF(G$5:G$32,"="&DATE(YEAR($A34),MONTH($A34), 1),H$5:H$32)-SUMIF(G$5:G$32
,""&DATE(YEAR($A34),MONTH($A34),29),H$5:H$32)

TIA

Radeesh


And what is your problem?

If you want to use the actual last day of the month, you could define it as:

DATE(YEAR($A34),MONTH($A34)+1,0)


--ron

I was looking to use the actual last date as some amounts are on 30th & 31
st in some rows.

Thank you Ron

Radeesh


"Ron Rosenfeld" wrote in message
...
On Wed, 17 Sep 2003 14:48:38 +0530, "Radeesh"
wrote:

Hi

I am using a formula to get a sum amounts between the first of the month
and
the last day of the month. I am using 29 as the last day of the month.
months run from August to April.


=SUMIF(G$5:G$32,"="&DATE(YEAR($A34),MONTH($A34), 1),H$5:H$32)-SUMIF(G$5:G$3
2
,""&DATE(YEAR($A34),MONTH($A34),29),H$5:H$32)

TIA

Radeesh


And what is your problem?

If you want to use the actual last day of the month, you could define it
as:

DATE(YEAR($A34),MONTH($A34)+1,0)


--ron

On Wed, 17 Sep 2003 18:56:08 +0530, "Radeesh" wrote:

I was looking to use the actual last date as some amounts are on 30th & 31
st in some rows.

Thank you Ron

Radeesh

Then that formula I posted should work. It takes advantage of the fact that
Excel interprets the 0th day of a month as the last day of the previous month.


--ron