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!