Hi,
I have a column for payment due dates on my Excel table (Office 2003 -
Windows XP Pro - SP2) which I would like to group by months with a pivot
table, however some of the dates in the column are not available exactly so
it says "not available" in the corresponding cell. I konw that "blank cells"
and "non date format cells" are not allowed for grouping.
Is there any other way of adding these "not available" text to be included
in the grouped columns by month?
Thanks