Updating week number, start date of the week, and year from a column date that's populated

Good Day,

I hope this question finds you well.

I have a sheet with some columns that needs to be populated by people in my team. Once a person changes a value in any cells for columns A, E, F, G, H it should populate the updated date and username automatically (this seems to work but not always for some reason).

From this updated date in Column I, I would like the year, week number, and the date for that particular week (starting on a Monday) to be populated each time. With that said, once this update occurs based on the original date value in column I, it should not change the values in Column I or J. I hope this makes sense.

I have read a few article on forums, but can not find something that works for me as I am not an vba expert.

Basically column I and J is populated once anything changes in certain columns and then column I (green) is used to populate the yellow columns without changing the exiting column I and J again.

I have even tried the more basic WEEKNUM, but then nothing works column I and J. I would rather have everything running from vba to be automatic without dragging or adjusting formulas in sheets when data row entries increases over time.

Attached is a example file.

I thank you in advance.

Kind Regards,

Ray

Hi Sintek,

Thank you very much for your fast reply and the perfect short solution to my question and problem. Thanks a million.

Hi Sintek,

As per your advise, here is the new file. I was wondering, if I would like to add dates manually for deliverable's how would the vba code look like to populate the year, week, week start date (Monday for that week).

So basically if I add in Column D (green) a manual date it should populate columns E, F, G (yellow).

Thanks once again for your help.

Attached the example file.

Thank you once again you are the best! Have a good one!