Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Middle date of two dates
Using a formula, how do I calculate the middle date of two dates?
e.g. What is the centre date of 07/08/08 and 15/05/09? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Middle date of two dates
Depending on how accurate you want to be...
A1 = 07/08/08 B1 = 15/05/09 =MEDIAN(A1:B1) =ROUND(AVERAGE(A1:B1),0) The first one returns 25/12/2008 The second one returns 26/12/2008 -- Biff Microsoft Excel MVP "Mally" wrote in message ... Using a formula, how do I calculate the middle date of two dates? e.g. What is the centre date of 07/08/08 and 15/05/09? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Middle date of two dates
Thank you for your help
"T. Valko" wrote: Depending on how accurate you want to be... A1 = 07/08/08 B1 = 15/05/09 =MEDIAN(A1:B1) =ROUND(AVERAGE(A1:B1),0) The first one returns 25/12/2008 The second one returns 26/12/2008 -- Biff Microsoft Excel MVP "Mally" wrote in message ... Using a formula, how do I calculate the middle date of two dates? e.g. What is the centre date of 07/08/08 and 15/05/09? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Middle date of two dates
You're welcome!
-- Biff Microsoft Excel MVP "Mally" wrote in message ... Thank you for your help "T. Valko" wrote: Depending on how accurate you want to be... A1 = 07/08/08 B1 = 15/05/09 =MEDIAN(A1:B1) =ROUND(AVERAGE(A1:B1),0) The first one returns 25/12/2008 The second one returns 26/12/2008 -- Biff Microsoft Excel MVP "Mally" wrote in message ... Using a formula, how do I calculate the middle date of two dates? e.g. What is the centre date of 07/08/08 and 15/05/09? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dates - Need to display date one month prior to user-entered date | Excel Worksheet Functions | |||
remove dates is the middle of a line | Excel Discussion (Misc queries) | |||
report date - date rec.ved=days late, but how to rid dates complet | Excel Worksheet Functions | |||
Date in middle of month | Excel Discussion (Misc queries) | |||
Remove middle initial from "first name middle initial" | Excel Discussion (Misc queries) |