How to automate the Expiry Period by having irregular validity(yrs)?

[elmer]

Purchase Yr Purchase Month Validity (Yrs) Expiry Period

2011 3 0.75 ?

2011 3 1.08 ?

2011 3 1.45 ?

2011 3 2 201303

2011 3 5 201603

2011 3 10 202103

 

[Hui]

Elmer

Assuming that 2011 03 0.75 is in Row 2

In cell D2 put: =DATE(A2+INT(C2),B2+12*(C2-INT(C2)),1)

Then format the cell using a Custom number format of YYYMM

 

[elmer]

Dear Hui, thank you so much for replying my query. It really works for my model.


Cheers!