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