![]() |
|
#1
|
|||
|
|||
|
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 |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
Sort data by month and by dates
|
Marcia | Excel | 4 | 05-30-2018 01:51 AM |
Unable to sort dates in Excel on new PC
|
freebird795 | Excel | 3 | 12-07-2014 03:06 PM |
| Conditional Formatting - color only dates contained in a range | EC37 | Excel | 1 | 07-08-2014 12:51 PM |
Generic range for custom sort macro?
|
tswiers | Excel Programming | 2 | 08-11-2011 02:40 AM |
| Sort Range | boutells | Excel | 1 | 07-15-2009 03:02 AM |