M Mally Jan 30, 2009 #1 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?
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?
T T. Valko Jan 30, 2009 #2 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
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
M Mally Jan 30, 2009 #3 Thank you for your help T. Valko said: 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 Click to expand...
Thank you for your help T. Valko said: 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 Click to expand...
T T. Valko Jan 30, 2009 #4 You're welcome! -- Biff Microsoft Excel MVP Mally said: Thank you for your help Click to expand...
