I am having issues on a calculation to change x axis dynamically to monthly/daily/weekly.
The formula below is updating every calculation except the sorting.
The dates are not sorted properly. As you can see April 1st, 2018 should be in the last and is in middle of the chart when any period is selected.
Also i want week should display as mm/dd/yy format. I am not able to change the format.
Any suggestions would be helpful. Attached is the workbook for your reference.