Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Sort range of dates into weeks
Register FAQ

Reply
 
Thread Tools Display Modes
  #1  
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, 9 views)
Last edited by Purfleet; 09-14-2020 at 11:15 AM. Reason: attachment
Reply With Quote
Reply

« Previous Thread | Next Thread »


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 09:10 AM.

Contact Us - Privacy Statement - Top

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