S
scribbler1382
Hoping someone can help, I'm about to lose my mind. I've tried every
combination of sum, if, countif, sumproduct, you name it and I can't
figure it out.
I've got a column of dates. What I want to do is count the number of
dates that occurred last month, taking into consideration that a year
change could be between the current month and last month.
This was my latest attempt, but again it didn't work:
=SUM(IF(MONTH(C2:C8)=MONTH(TODAY()-DAY(TODAY())),1,0))
If you can save what's left of my sanity, please help.
Cheers,
Scrib
combination of sum, if, countif, sumproduct, you name it and I can't
figure it out.
I've got a column of dates. What I want to do is count the number of
dates that occurred last month, taking into consideration that a year
change could be between the current month and last month.
This was my latest attempt, but again it didn't work:
=SUM(IF(MONTH(C2:C8)=MONTH(TODAY()-DAY(TODAY())),1,0))
If you can save what's left of my sanity, please help.
Cheers,
Scrib