Thank you for your time helping me - its got my head in the right space for it to work. I need some time to come back to this - the workbook has 10000 lines of code in and I have to get this finished before I can test and im finding issues with the data which I need to write further code around. I will come back to you shortly - I think I can put it into a formula also now I have the logic around it. I have also worked out the date from a year/week using the above methodology. I will share it all when all done and tested to see if there are improvements or issues.
Thank you again