Hi,
I have table containing list of dates in Column A. I would like the value in Column B to be "mmm-yyyy". For Column C, I would like to return the value to week number.
Week No. Day From Day To
Week 1 1 7
Week 2 8 14
Week 3 15 21
Week 4 22 31
How can I automate this using VBA. Please note the I will be updating the column A from time to time. Hence, I am hoping that the code will not be a specific range only. The code will only stop on the last row of the table.
thanks
Bookmarks