Hi guys,
I have a list of hundreds of dates. Each entry represents when someone “signed-up”.
My end result should be a line chart where:
- the horizontal axis is time (months over 3 years)
- the vertical axis is number of sign-ups
So let's say the first part of my data looks like this:
- Feb 8, 2010
- Mar 3, 2010
- Mar 7, 2010
- Mar 20, 2010
- Apr 13, 2010
- So, moving across the chart from left to right, first month (Jan 2010), line is at 0
- Above Feb 2010 tick at bottom the line climbs to 1 (Feb 8)
- Above Mar 2010 tick the line climbs to 4 (3 sign ups for Mar)
- and so on and so on..
I tried formatting the date to by just month and year. I was trying to use a COUNTIF function
=COUNTIF(C2:C125,"Feb 2010")
..but this didn’t work because the data was still in the format 2/8/2010.. and I’d have to write the equation for each month..
There’s got to be a way to automate this..
Bookmarks