Forum Discussion
Pivot table and date sorting/grouped by months/years when empty cells in selected data
Donald_Genes_ All my blank cells are "true blank", I checked with the function Isblank(), but still not able to group dates. Do you have any suggestions? Thank you in advance
Do you have dates (which are actually numbers) or texts which looks like dates? You may check by ISNUMBER(). Also, do you have any other texts in Date column?
- alexcerciAug 20, 2022Copper Contributor
SergeiBaklan I have the date column formatted as date. When I insert a pivot table and try to group the dates it tells me the error "cannot group...". I attach here a similar scenario.
- SergeiBaklanAug 21, 2022Diamond Contributor
It doesn't matter how Date column is formatted. If you apply date or number format to the text, it still will be a text. Formatting doesn't convert the value.
Here is the sample with dates (=ISNUMBER() returns TRUE) and texts which looks like dates
Again, please be sure you have dates, not texts.
- alexcerciAug 21, 2022Copper Contributor
SergeiBaklan the cells which contain dates are numbers, the blank cells are not, I checked with ISNUMBER(). The problem is that whatever method I use to convert the blank cells to numbers they are not working, if I use the ISNUMBER() it keeps telling me FALSE.