Our business uses ISO weeks for everything, so I am trying to take date data out of SAP and make it usable in calculations in an ISO week format.
Currently I am doing this:
Cell 1
Cell 2=ISOWEEKNUM(cellwithdate)
Cell 3=Year(cellwithdate)
Result:=Concatenate(Cell 2," ",Cell 1)
2019 9
Problem is what Excel recognizes 2019 9 as larger than 2019 16.
Is there a better way to do this? We have orders being analyzed from current year, previous year and next year. I believe it needs the space or else it will think 20193 is smaller than 201020 (week 3 2019 vs week 20 2010)
This is the supplied date format by the way:
2019-10-25
Bookmarks