Hi:

Attached is an Excell SS with a simple column of dates, headed at the top with example "results" of what I need two Excel formulas for.

I simply need formulas for determining the earliest month & year -- and the latest month & year --from the column, and return the results in the format, for example, "December, 2010"

Bear in mind the column of dates will always be a

__different __number of rows. In one reporting period there may be 50 rows of dates, in others it may be 200 rows of dates. The first row will always be fixed but the last row, obviously, will always be different based on the varying number of dates.

Thanks in advance!

Dates.xlsx
=TEXT(LARGE(INDEX(LEFT(A7:

and for end

=TEXT(MAX(INDEX(LEFT(A7:A1

Assumes that dates start at A7 and may go as far as A1000, adjust as required. Note this works for US regional settings, may not work for other regional settings.

see attached

regards, barry

26875028.xlsx