=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