Hi....

Just wondering if anyone could help me with a formula or suggest how I may
do the following:

I have a list of contracts with dates from and to and would like to
calculate the number of months in each contract and which financial year they
fall in (financial year running from 01/04 - 31/03) for example:

Contract A: 01/01/08 - 01/06/09 this will have 3months in 07/08 12 in 08/09
and 2 in 09/10.

Any help will be appreciated.

Thanks