I have a spreadsheet with a range of random dates in column A. I am looking for a way to group the dates into weeks.

For example if the date range contains the dates:
8/31/2020
9/3/2020
9/6/2020
9/8/2020
9/18/2020

The result would look something like:
8/31/2020 to 9/3/2020 = WEEK 1
9/6/2020 to 9/18/2020 = WEEK 2

Screen shot of actual sheet attached.

Thanks
MAC

Attached Files

Excell Screen Shot.docx (211.4 KB, 10 views)