Thread: Sort range of dates into weeks
View Single Post
 
Old 09-14-2020, 11:05 AM
Purfleet Purfleet is offline Windows 10 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