Hello, I am trying to create a pivot table of monthly expenses. My download of expenses is by date. I want to create a summary by month or year. How can I split the date (for example 12/5/2009 as Day, Month and year 5 in column B, December in column c and 2009 in column D?
Thank you.