How do I calculate the midpoint date between two dates.

[Allan]

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]

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

--
Kind regards,

Niek Otten

"Allan" <[email protected]> wrote in message news:[email protected]...
| 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]

Thanks, Niek!


"Niek Otten" wrote:

> =INT(MONTH((A1+B1)/2)/3)+1&"-"&TEXT(YEAR((A1+B1)/2),"00")
>
> --
> Kind regards,
>
> Niek Otten
>
> "Allan" <[email protected]> wrote in message news:[email protected]...
> | 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]

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.