Hi Maxi,

Assume your data range A1:C1

In D1, try this array formula
=MAX(DAY($A1:$C1))

Confirm the formula by Ctrl+Shift+Enter

Does it help?


"Maxi" wrote in message
ups.com...
Sorry. I framed the question incorrectly.

I want to check the first occurring date of each month and then compare
it with the next occurring first date of the next month in the array
and then find out the max date.

Eg.
First row:
First date in May 9th, in June 1st, in Jul 13th hence the result should
be 13

Second row:
First date in May 13th, in June 6th, in Jul 1st hence the result should
be 13

Maxi