Remaining life formula

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

One thing that i forgot to mention is that i would like it if possible to be dynamic e.g. next year the formula would still work even though the start of the financial year was 01/04/14 etc

Hi

Try this. I've used a couple of helper cells but you may want to combine them. I've assumed that you will enter a new FY start date.

Cheers
Alan