Remember Me?

#1
January 30th 09, 09:36 AM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Jun 2008 Posts: 73
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
January 30th 09, 09:52 AM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Nov 2006 Posts: 15,768
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
January 30th 09, 10:05 AM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Jun 2008 Posts: 73
Middle date of two dates

"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
January 30th 09, 05:53 PM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Nov 2006 Posts: 15,768
Middle date of two dates

You're welcome!

--
Biff
Microsoft Excel MVP

"Mally" wrote in message
...

"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?

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post brettopp Excel Worksheet Functions 13 December 3rd 07 06:58 PM jason2444 Excel Discussion (Misc queries) 2 June 20th 07 03:55 AM MS Questionnairess Excel Worksheet Functions 3 January 25th 07 07:17 PM Sunnyskies Excel Discussion (Misc queries) 10 October 23rd 06 03:23 PM Justin F. Excel Discussion (Misc queries) 15 September 26th 05 06:13 PM

All times are GMT +1. The time now is 09:55 PM.