Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

determine min and max dates (date/month) froma series of dates

Hi I'm hoping someone can help me with the following problem: I have a series of dates in two columns and I would like to determine which is the min-date and max-date (based on day & month onlyC:\fakepath\Min&max dates.ods) over all years in each column.

See the attached sample spreadsheet.

The red-colored cells are manually edited to show the expected results.

Thanks in advance Fred