Use the MEDIAN function, as in:

=MEDIAN(A1:A6)

On Nov 16, 1:25 pm, Pammy wrote:
I have a column that has entries that start with Fiscal year 07 numbers which
are from 07/01/07 to 06/30/08, and a cell that gives me the average so far
this year. Is there a way to take this col Fiscal year and get a median for
FY07-08?