Can you attach workbook and what you trying to do in 2-3 lines?
Sorry, I'm not able to attach anything I'm afraid - apologies if my description is not clear enough. To try to make it clearer I'm trying to:
Take a date, add a number of months to it based on an indicator from the same data set, that is used to look up the appropriate number of months from a second data set. Once this is done I need to update the newly calculated date to the last day of the year that is reached once the months are added. Simple??!!
Hope this helps you to help me.....