I am still struggling to get the 'formula' to work. I want to be able to choose a date on the document (so using a drop down list) and then the expiry date should automatically populate to be a year from now less 1 day. Could you write the exact code (or explain what each line item is for) to be able to do this?

I can send you the file in order to assist?