=DATEDIF(B14,B4,"m")

[teeb]

I've used the formula =DATEDIF(B14,B4,"m") for calculating the number of months between two date. Changing the m to a y does the number of years.

How can I the number of quarter years? I've tried the logical Q to no joy!

Also need to know the termly figure? ie How many 4 month segments (in one year the value would be 3)

Any suggestion much appreciated

[JE McGimpsey]

How about:

Quarters:

=DATEDIF(B14,B4,"m")/3


Or, if you only want whole quarters, rather than fractional quarters
(there's a pun in there somewhere):

=INT(DATEDIF(B14,B4,"m")/3)

For 4-month segments:

=DATEDIF(B14,B4,"m")/4




In article <[email protected]>,
teeb <[email protected]> wrote:

> I've used the formula =DATEDIF(B14,B4,"m") for calculating the number of
> months between two date. Changing the m to a y does the number of
> years.
>
> How can I the number of quarter years? I've tried the logical Q to no
> joy!
>
> Also need to know the termly figure? ie How many 4 month segments (in
> one year the value would be 3)