More Excel Help, please.

[SansSuit 1]

I thought I saw this asked before but I haven't been able to find the answer.

I have a list of dates in a range (dates I made jumps). I would like to know how many of those dates are in each calendar months .... How many jumps in June, etc.

The attached file kinda shows what I need.

Thanks!

Peace,
-Dawson.
http://www.SansSuit.com
The Society for the Advancement of Naked Skydiving

[Squeak 17]

Filter for the months in question

click the fiels you want to filter then click the funnel looking icon

You are not now, nor will you ever be, good enough to not die in this sport (Sparky)
My Life ROCKS!
How's yours doing?

[murrays 0]

Could you use countif? You'd have to figure out how to set the criteria but I think it may work for you.

--
Murray

"No tyranny is so irksome as petty tyranny: the officious demands of policemen, government clerks, and electromechanical gadgets." - Edward Abbey

[Nataly 38]

Here ya go

"There is no problem so bad you can't make it worse."
- Chris Hadfield
« Sors le martinet et flagelle toi indigne contrôleuse de gestion. »
- my boss

[flyhi 24]

In "American" format (month first) and colorful.

Shit happens. And it usually happens because of physics.

[DiverMike 5]

I vote for Nataly's since it is a little less klunky. Your method of finding all cells past a certain date and then subtracting all those a month older seems to be a roundabout way to do it, but it works.

Nataly's version is a simpler formula, but requires non visible cells to work. It will break in the year 2011 unless you change the cells starting in 2010. Example 3.201 needs to become 3.2010 in order to allow for a 3.2011.

And you are right - she has that wierd european date format

For the same reason I jump off a perfectly good diving board.

[Nataly 38]

There are "better" ways of doing it, but I thought I'd keep it simple... I'm assuming whoever would ask this kind of question would want to just copy/paste formulas down..

And it will work in 2011 without any changes

"There is no problem so bad you can't make it worse."
- Chris Hadfield
« Sors le martinet et flagelle toi indigne contrôleuse de gestion. »
- my boss

[DiverMike 5]

Quote

And it will work in 2011 without any changes

oops - you are correct. Sorry

For the same reason I jump off a perfectly good diving board.

[SansSuit 1]

Thanks, both of you! I used the basic structure of flyhi's formula. I'm in the process of reworking my whole SuperMegaLogPlus (pat. pend.). One of the changes I'm after is to reduce columns whenever possible. Plus I can wrap my head around just what is happening.

And for the record, I also asked in an Excel Help Forum. I got one answer that really didn't help.

Thanks again !!

Peace,
-Dawson.
http://www.SansSuit.com
The Society for the Advancement of Naked Skydiving

[gemini 0]

Here's another version that works in your format.

Blue skies,

Jim