last day of the month in a range
 

in column A there are dates like

01/15/2004
01/25/2004
02/03/2004
16/03/2004

last day of the month in a range
 

Not sure what the question is but if you use =MAX(a1:a4) it will return the
last date of range. But I suspect this is not want you want?

--
Cheers
Nigel



"barkiny" wrote in
message ...

in column A there are dates like

01/15/2004
01/25/2004
02/03/2004
16/03/2004

last day of the month in a range
 

Hi

Which month
All ?

--
Regards Ron de Bruin
http://www.rondebruin.nl


"barkiny" wrote in message
...

in column A there are dates like

01/15/2004
01/25/2004
02/03/2004
16/03/2004

last day of the month in a range
 

yes
for each motnth

it will return

01/25/2004 in cell A1 and 16/03/2004 in cell A2


--
barkiny
------------------------------------------------------------------------
barkiny's Profile: http://www.excelforum.com/member.php...o&userid=20397
View this thread: http://www.excelforum.com/showthread...hreadid=490715

last day of the month in a range
 

Mmmmm

I have a solution but I think it is not very good
I send a mail to a friend that have more knowledge then I about this.

I hope he reply


--
Regards Ron de Bruin
http://www.rondebruin.nl


"barkiny" wrote in message
...

yes
for each motnth

it will return

01/25/2004 in cell A1 and 16/03/2004 in cell A2


--
barkiny
------------------------------------------------------------------------
barkiny's Profile: http://www.excelforum.com/member.php...o&userid=20397
View this thread: http://www.excelforum.com/showthread...hreadid=490715

last day of the month in a range
 

Hi barkiny

Much better this solution from Bob Phillips

Assuming that the dates are in A1:A200, add this formula to B1

=IF(MAX(IF((MONTH($A$1:$A$200)=ROW(A1))*($A$1:$A$2 00<""),$A$1:$A$200))=0,"",MAX(IF((MONTH($A$1:$A$2 00)=ROW(A1))*($A$1:$A$200<""),$A$1:$A$200)))

It is an array formula, so it needs to be committed with Ctrl-Shift-Enter.
You will see the formula in the formula bar surrounded by {...}, which are
inserted by Excel. Then copy B1 down to B12.

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Ron de Bruin" wrote in message ...
Mmmmm

I have a solution but I think it is not very good
I send a mail to a friend that have more knowledge then I about this.

I hope he reply


--
Regards Ron de Bruin
http://www.rondebruin.nl


"barkiny" wrote in message
...

yes
for each motnth

it will return

01/25/2004 in cell A1 and 16/03/2004 in cell A2


--
barkiny
------------------------------------------------------------------------
barkiny's Profile: http://www.excelforum.com/member.php...o&userid=20397
View this thread: http://www.excelforum.com/showthread...hreadid=490715