I have been trying to figure this out all day:
I am building a dashboard, and I have everything in a summary tab (in a table) to pull for pivots. The dates do not seem to be recognized as dates when I try to use a pivot to group by date.
I have tried text to columns, and formatting cells. I have tried helper cells as well. Some rows are intentionally not populating a date because we haven't sold it yet, so there is no sale date. PLEASE help me figure this out.
I'm using 365
I am building a dashboard, and I have everything in a summary tab (in a table) to pull for pivots. The dates do not seem to be recognized as dates when I try to use a pivot to group by date.
I have tried text to columns, and formatting cells. I have tried helper cells as well. Some rows are intentionally not populating a date because we haven't sold it yet, so there is no sale date. PLEASE help me figure this out.
I'm using 365