Hi!

Try this....

Entered as an array using the key combo of CTRL,SHIFT,ENTER:

=MAX(DAY(A2:G2))

Biff

"Maxi" wrote in message
ups.com...
This is what I have in range A2:G2
9-May 17-May 1-Jun 15-Jun 13-Jul 14-Jul 18-Jul 18
13-May 6-Jun 12-Jun 20-Jun 1-Jul 16-Jul 20-Jul 20

I want to see the max date monthwise and then find out the max of all
the dates.

Eg. In Row 1 max figure for May is 17, June 15, July 18 hence Answer =
18
In Row 1 max figure for May is 13, June 20, July 20 hence Answer = 20

Maxi