Hi

In your original table, search and replace the "not available" cells
with a date that cannot be confused with your real data - either a date
way in the future or way in the past.
Then choose group by Date, but make the range to group be a range that
excludes this early or late date.

--
Regards

Roger Govier


"kuvulmaz" wrote in message
...
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