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


--
teeb
------------------------------------------------------------------------
teeb's Profile: http://www.excelforum.com/member.php...o&userid=13172
View this thread: http://www.excelforum.com/showthread...hreadid=388750