Unable to group by date in pivot table

Hi,

I have a table with a column of dates in, I have another column which uses a formula to add 2 working days onto the date in the first column. I want to do pivot tables on these columns which is fine and I can do that. the issue is I can group the dates form the first column in a pivot eve though there are blanks in the cells, but I cannot do the same for the 2nd column - no errors in the dates as they are the result of formulas and the same blank cells as the original column. I have tried to use the if true value to add in false date to make it work but can't get it to? Any thoughts as it is driving me mad! Example data attached with the two pivots set up, one grouped one not.

Thanks J

Administrative Note:

VAGUE GENERIC TITLE

We would very much like to help you with your query, however the thread title does not really convey what your request is about. Tell us what you are trying to do, not how you think it should be done.

Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)

Much better - thanks.

A cell with a formula returning "" is not the same as a blank cell. It's text, and that's what stops your dates from grouping.

You'll have to amend your formula to return 0 rather than "" and then filter out those dates.