Median Date
 

Hi,

Can I use the MEDIAN function to find the median of two dates? I tried and
it didn't seem to work. For example, I want to be able to know the middle
point between Feb. 18/04 and Mar. 23/04.

Thanks

Median Date
 

Those dates don't look to be in a typical date format. That may be par tof
your problem. I'm wondering if they are TEXT rather than dates. Put this
formula temporarily on your sheet =ISNUMBER( ) and select the cell with
one of the dates as the argument. You should get TRUE returned if it is
indeed a number.

HTH,
Barb Reinhardt


"jenn" wrote:

Hi,

Can I use the MEDIAN function to find the median of two dates? I tried and
it didn't seem to work. For example, I want to be able to know the middle
point between Feb. 18/04 and Mar. 23/04.

Thanks

Median Date
 

Hi,

The dates aren't in date format but i will type them in when I enter the
formula.
I only have about 30 to calculate I just thought it might be easier than
doing it in my head.

I have a column that says all kinds of different stuff like exact dates,
ranges, months only. I want to enter a formula in another column for just the
ranges.

A B
Between Feb 18/04 and Mar 23/04 =median(18/02/04,23/03/04
Dec. 01 15-Dec-01
March 26/03 26-Mar-03


"Barb Reinhardt" wrote:

Those dates don't look to be in a typical date format. That may be par tof
your problem. I'm wondering if they are TEXT rather than dates. Put this
formula temporarily on your sheet =ISNUMBER( ) and select the cell with
one of the dates as the argument. You should get TRUE returned if it is
indeed a number.

HTH,
Barb Reinhardt


"jenn" wrote:

Hi,

Can I use the MEDIAN function to find the median of two dates? I tried and
it didn't seem to work. For example, I want to be able to know the middle
point between Feb. 18/04 and Mar. 23/04.

Thanks

Median Date
 

Format the cells as dates and use

=MEDIAN(A1:A2)

where A1 holds 18-04-2004 and A2 23-03-2004

that will return

05-04-2004



--
Regards,

Peo Sjoblom




"jenn" wrote in message
...
Hi,

The dates aren't in date format but i will type them in when I enter the
formula.
I only have about 30 to calculate I just thought it might be easier than
doing it in my head.

I have a column that says all kinds of different stuff like exact dates,
ranges, months only. I want to enter a formula in another column for just
the
ranges.

A B
Between Feb 18/04 and Mar 23/04 =median(18/02/04,23/03/04
Dec. 01 15-Dec-01
March 26/03 26-Mar-03


"Barb Reinhardt" wrote:

Those dates don't look to be in a typical date format. That may be par
tof
your problem. I'm wondering if they are TEXT rather than dates. Put
this
formula temporarily on your sheet =ISNUMBER( ) and select the cell
with
one of the dates as the argument. You should get TRUE returned if it is
indeed a number.

HTH,
Barb Reinhardt


"jenn" wrote:

Hi,

Can I use the MEDIAN function to find the median of two dates? I tried
and
it didn't seem to work. For example, I want to be able to know the
middle
point between Feb. 18/04 and Mar. 23/04.

Thanks