Hi,

I have in column A a time series of consecutive daily dates covering around 5 years.

Can someone please suggest a formula that will return the latest date represented in column A for each month and year (e.g. 29 October for the month of October 2011 if column A contains the dates 1 to 29 October 2011) in the series.

Thanks very much!