Hi,

I would like some help with the following problem. I would like a formula that returns the time remaining to use a product at the start of each year.

e.g.

Data:
Product A was purchased 15/10/12 and has a two year (24 Month) life.
Financial year starts 01/04/13


Under the heading "useful life at the start of financial year" i would like the formula to return:
18 months

The logic being that the month it is bought in counts as a full month regardless of when in the month it is. At 01/04/13 the product had been bought for 6 months and so had 18 months remaining.

Hope this is clear. Let me know if further clarity is needed.

THanks in advance.

Many thansk,

C