Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I'm trying to group by date in an Excel 2010 pivot table.

The column with dates (i.e., the one want to group by), should be the latest date of 2 other columns if neither is null, or blank. i.e., with a formula like:

=IF(AND(A4 <> "", B4 <> ""), MAX(A4,B4), "")

Normally, this ""in the IF() formula acts the same as an empty cell. In this case, it is preventing me from grouping by date in the Pivot Table. If I filter the date column by (Blanks), then clear the contents of all those cells, then the pivot table does group by date ok. i.e., "" is not being treated the same as an empty cell.

share|improve this question

i usually use 0 (number, i.e.: 0.1.1900 date) instead of "" (empty string) and this number format: [=0]"";d.m.yyyy

  • since you use , as a list separator, the number format will probably look like '[=0]"",m/d/yyyy' for you, but i don't know for sure
  • in the pivot table, you will find these "blank" values under the year 1900 - i've never had to use actual dates from 1900, so there was no confusion
share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .