Edate help

[Mrthye]

I have column D filled with dates starting at D8. They are formatted MM/DD/YYYY and span several years, and a new date is added manually every few days.
I needed to count how many cells have a date that falls in the current month and year, and I found another post that suggested using SUMPRODUCT. I was able to alter a formula I found to do this, though I really don't understand what the SUMPRODUCT formula is actually doing, I just fumbled around with it until it worked:
=SUMPRODUCT(--(MONTH(D8:D9999)=MONTH(TODAY())),(--(YEAR(D8:D9999)=YEAR(TODAY()))))

However, now I am asked to get a similar count of the number of cells that have a date that falls in the last month and the month before that.

I have been trying to alter my SUMPRODUCT formula with the EDATE function, but I have been unable to find a way to make anything work. I have tried several COUNTIF formulas to achieve the same data count, but still can't come up with anything.

Any suggestions?

 

[Fluff]

Hi & welcome to MrExcel.
Are you trying to count all dates from the 1st of Feb to 31st Mar?

 

[Mrthye]

I am trying to count all cells that have a date that is in February, but next month (April) I want it to show the last month's count (March). I'm trying to get a rolling monthly total so I don't have to edit the formula each month

 

[Scott Huish]

=SUMPRODUCT(--(TEXT(D8:D9999,"mmyyyy")=TEXT(EDATE(TODAY(),-1),"mmyyyy")))

 

[Mrthye]

Thank You! I didn't realize I had to include TEXT in the first part!

 

[Scott Huish]

Thank You! I didn't realize I had to include TEXT in the first part!

There are ways not to, but this makes it simpler.