Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Max/Min/Median | Excel Worksheet Functions | |||
median function | Excel Worksheet Functions | |||
median excluding 0's | Excel Worksheet Functions | |||
Median function | Excel Discussion (Misc queries) | |||
Finding Median if a value = 1.. help! | Excel Worksheet Functions |