ExcelBanter - How do I calculate the midpoint date between two dates.

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How do I calculate the midpoint date between two dates. (https://www.excelbanter.com/excel-worksheet-functions/83814-how-do-i-calculate-midpoint-date-between-two-dates.html)

Allan

How do I calculate the midpoint date between two dates.

Can anyone help!

I have August 2006 (start) and August 2008 (end). I need the midpoint
between those two months and provided in QTR-YR.

Niek Otten

How do I calculate the midpoint date between two dates.

=INT(MONTH((A1+B1)/2)/3)+1&"-"&TEXT(YEAR((A1+B1)/2),"00")

--
Kind regards,

Niek Otten

"Allan" wrote in message ...
| Can anyone help!
|
| I have August 2006 (start) and August 2008 (end). I need the midpoint
| between those two months and provided in QTR-YR.

Allan

How do I calculate the midpoint date between two dates.

Thanks, Niek!

"Niek Otten" wrote:

=INT(MONTH((A1+B1)/2)/3)+1&"-"&TEXT(YEAR((A1+B1)/2),"00")

--
Kind regards,

Niek Otten

"Allan" wrote in message ...
| Can anyone help!
|
| I have August 2006 (start) and August 2008 (end). I need the midpoint
| between those two months and provided in QTR-YR.

Allan

How do I calculate the midpoint date between two dates.

Niek,

I just notice something, I inputted June 2006 and July 2007 and it gave me a
5-2006 midpoint? How did it get a 5th qtr??

"Allan" wrote:

Can anyone help!

I have August 2006 (start) and August 2008 (end). I need the midpoint
between those two months and provided in QTR-YR.

All times are GMT +1. The time now is 05:46 AM.