last day of the month in a range

[barkiny]

in column A there are dates like

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

how can i a macro so that it gives the last days of that month like

01/25/2004
16/03/2004

thanks in advance

[Nigel]

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" <[email protected]> wrote in
message news:[email protected]...
>
> in column A there are dates like
>
> 01/15/2004
> 01/25/2004
> 02/03/2004
> 16/03/2004

[Ron de Bruin]

Hi

Which month
All ?

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


"barkiny" <[email protected]> wrote in message
news:[email protected]...
>
> in column A there are dates like
>
> 01/15/2004
> 01/25/2004
> 02/03/2004
> 16/03/2004

[barkiny]

yes
for each motnth

it will return

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

[Ron de Bruin]

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" <[email protected]> wrote in message
news:[email protected]...
>
> 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
>

[Ron de Bruin]

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$200<>""),$A$1:$A$200))=0,"",MAX(IF((MONTH($A$1:$A$200)=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" <[email protected]> wrote in message news:O5pjiCm%[email protected]...
> 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" <[email protected]> wrote in message
> news:[email protected]...
>>
>> 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
>>
>
>