Sort range of dates into weeks
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
|