I receive excel data from six outside agencies on a monthly schedule. One of
the columns is Date. When I put all the data together on one ss, I can create
a pivot table but I cannot group the dates. (I know it is a date format
problem as I created a dummy ss from scratch and was able to create the
chart.) Each date cell has a green tic in the top left corner. Format|Cells
tells me it's a date but the infobox next to each date cell shows me a list
of options. How can I take the existing column of dates and maybe move them
to a new column with a correct date format so that I can use that column in
my pivot table? Hope that's clear! Thanks...