Forum Discussion
Solved
Sort by chronological date for 'mm/yyyy' format?
Hello, I have a calculated field that extracts month and year from a date field using the TEXT function: TEXT(A2, "mm/yyyy") Example: 01/2022 The problem I've having is that my dataset spans...
Thank you, Hans - this delivers the right field format, but doesn't help with the sorting problem I described above. How can I get these dates to sort in month/year order?
Have you tried sorting it? It should work.
HansVogelaar OK - got it, I had missed that my Running Total was associated with my original formula field instead of the updated one I inserted from you: (=$K2-DAY($K2)+1). This worked - thank you!