Cleaning up date range colums

[ginotx]

I am working on creating a table for production of plants for others to use in Excel. All info is exported from SBI. SBI exports the info as week of the year and year number

imported to Excel date examples: 0123, 2623, 4823, 0124, 2624, 4824, 0125,2625,4825

For sorting purposes I currently have a column for the week number of year (1-52) and a separate column for the year (23,24,25,26) for production year and year the trees will be ready. What i am hoping is that i can put the dates in one column and have a way to separate the years. I currently split the dates out when importing to Excel but would like a way to sort dates in Excel where I would only need one column. The problem i have is that I want to sort by year, then by week number. Currently I am unable to sort by year first unless I use two columns.

SBI Export Date examples: 0123, 2623, 4823, 0124, 2624, 4824, 0125,2625,4825

Currently i make two columns but would like to not split the date into two columns to sort by year, then week of the year.

Thank You

 

[felixstraube]

I don't quite understand your problem. You don't want 2 columns but you want to be able to filter by year and by week?
There is no way to sort by week in excel filters that i know of if you have one column of dates. Just by year, month and so forth. I think you are stuck with 2 columns.

 

[ginotx]

That is what I concluded, but was hoping otherwise.

Below is pretty much what I am doing now with my own split of week and year vs the SBI import date. What I have works, I was just hoping to clean up.

Plant Name	Sales 2023	Vendor	Order Date	Shipped	Plug Size	Week	Year	SBI Import Date
ACHILLEA MOONSHINE	1138​	BALL	10/12/23​	800	102​	6	2024	624
ACHILLEA MOONSHINE	1138​	McH	10/12/23​	792	72​	8	2024	824
ACHILLEA NEW VINTAGE RED	210​	BALL	10/12/23​	200	102​	6	2024	624
ACHILLEA NEW VINTAGE RED	210​	McH	10/12/23​	288	72​	6	2024	624
AEGOPODIUM PODAGRARIA SNOW ON THE MOUNTAIN		McH	10/12/23​	100	50​	6	2024	624
AEGOPODIUM VARIEGATUM	86​	BALL	10/12/23​	72	72​	6	2024	624
AGASTACHE BLUE BOA	161​	BALL	10/12/23​	144	72​	6	2024	624

 

[felixstraube]

I think that is the best you can do.