View Single Post
 
Old 09-14-2020, 09:14 AM
MAC Solutions MAC Solutions is offline Windows 10 Office 2007
Novice
 
Join Date: Sep 2020
Location: Tennessee
Posts: 5
MAC Solutions is on a distinguished road
Default 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
Attached Files
File Type: docx Excell Screen Shot.docx (211.4 KB, 4 views)
Reply With Quote