View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default 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?