Hi There,
I have a large amount of data that shows me the exact date that certain activities were performed.
I need to then show these activities consolidated in a pivot table by activity performed in Week Ending (using Sunday as the week ending date)
I have attached aspreadsheet with the 2 columns - date worked (column A) and week ending (column B)
Can anybody please help with a script that will review each row and then insert the week ending in the format dd-mmm-yyyy.
Thanks, Marshybid