Grouping Data by Date

calendarTechniques for Grouping Data by Date in Excel

If you have a large data set that includes transaction dates, you may want to aggregate amounts by certain dates.  The problem is that you have a separate date for each day of the year.  This makes any meaningful analysis difficult.
It would help if just the month or year could be extracted so that data could be accumulated.  Well, there are functions for that.  There’s a year function, a month function and a day function that will extract the year, month and day from a date.
The syntax is the same for all functions.  Using =year as an example, the syntax is =year(cell with date).  The example below uses 7/15/2015. More….

 

Leave a Reply

Your email address will not be published. Required fields are marked *

  • “The course on ethics was one of the best correspondence courses I ever used.  It was well organized and the examples used were extremely helpful.”

    - Tommy R.

  • Great course! Price was right and the material was very thorough.

    - Alex

  • ” This was my first experience with CPASelfStudy.com and I was very impressed. I will definitely consider taking CPE through CPASelfStudy.com in the future.”   12/2017

    - Christopher Q.