Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-14-2020, 09:14 AM
MAC Solutions MAC Solutions is offline Sort range of dates into weeks Windows 10 Sort range of dates into weeks Office 2007
Novice
Sort range of dates into weeks
 
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, 8 views)
Reply With Quote
  #2  
Old 09-14-2020, 09:47 AM
Purfleet Purfleet is offline Sort range of dates into weeks Windows 10 Sort range of dates into weeks Office 2019
Expert
 
Join Date: Jun 2020
Location: Essex
Posts: 345
Purfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to behold
Default

Cant you just upload the workbook rather than a word doc with a screen shot?


Try pivot tables - you can group by 7 days and works well nornmally
Reply With Quote
  #3  
Old 09-14-2020, 10:34 AM
MAC Solutions MAC Solutions is offline Sort range of dates into weeks Windows 10 Sort range of dates into weeks Office 2007
Novice
Sort range of dates into weeks
 
Join Date: Sep 2020
Location: Tennessee
Posts: 5
MAC Solutions is on a distinguished road
Default Reply

Thanks for your response. I have attached a copy.
Attached Files
File Type: xlsm Book1.xlsm (492.5 KB, 6 views)
Reply With Quote
  #4  
Old 09-14-2020, 11:05 AM
Purfleet Purfleet is offline Sort range of dates into weeks Windows 10 Sort range of dates into weeks Office 2019
Expert
 
Join Date: Jun 2020
Location: Essex
Posts: 345
Purfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to behold
Default

Pivot grouped by dates.


There were a couple of dates in as text which need to be fixed.


is this what you were after or do you need a week number?
Attached Files
File Type: xlsx Book1_PURFLEET.xlsx (198.3 KB, 7 views)

Last edited by Purfleet; 09-14-2020 at 11:15 AM. Reason: attachment
Reply With Quote
  #5  
Old 09-14-2020, 02:27 PM
MAC Solutions MAC Solutions is offline Sort range of dates into weeks Windows 10 Sort range of dates into weeks Office 2007
Novice
Sort range of dates into weeks
 
Join Date: Sep 2020
Location: Tennessee
Posts: 5
MAC Solutions is on a distinguished road
Default

This works great, thank you.
Reply With Quote
  #6  
Old 09-14-2020, 02:53 PM
MAC Solutions MAC Solutions is offline Sort range of dates into weeks Windows 10 Sort range of dates into weeks Office 2007
Novice
Sort range of dates into weeks
 
Join Date: Sep 2020
Location: Tennessee
Posts: 5
MAC Solutions is on a distinguished road
Default

When I created a new pivot table I can't group by time. How do you turn that on?
Reply With Quote
  #7  
Old 09-14-2020, 11:04 PM
Purfleet Purfleet is offline Sort range of dates into weeks Windows 10 Sort range of dates into weeks Office 2019
Expert
 
Join Date: Jun 2020
Location: Essex
Posts: 345
Purfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to behold
Default

Time isnt in your data is it?


From memory time and dates automatically group if they are formatted correctly
Reply With Quote
  #8  
Old 09-19-2020, 05:40 AM
MAC Solutions MAC Solutions is offline Sort range of dates into weeks Windows 10 Sort range of dates into weeks Office 2007
Novice
Sort range of dates into weeks
 
Join Date: Sep 2020
Location: Tennessee
Posts: 5
MAC Solutions is on a distinguished road
Default

Thank you for your help, with it have been able to get it working the way I wanted it to. You are correct on the date issue. The data imported into the worksheet was not a date data type. When that was corrected it worked perfectly.

Thanks Again
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sort range of dates into weeks Sort data by month and by dates Marcia Excel 4 05-30-2018 01:51 AM
Sort range of dates into weeks 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
Sort range of dates into weeks 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

Other Forums: Access Forums

All times are GMT -7. The time now is 01:01 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft