how would you consolidate dates so you just had the month/year in excel vba?
i have a worksheet (raw data) that has date in column A, miles travelled in column B and i want to create a summary report on a seperate worksheet (report) based on month/year (mmm/yyyy) in column A, total miles...