Middle date of two dates

M

Mally

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

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

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculating interest due on late loan payments 1
counting based on two dates 2
How do I add amounts referencing specific dates? 7
Conditional Formatting 1
Find Period Date? 5
Date Formula 1
help with a formula 2
Find within Date Range 4

Top