Count dates for previous month
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 |
Count dates for previous month
Try...
=SUMPRODUCT(--(C2:C8-DAY(C2:C8)+1=DATE(YEAR(TODAY()),MONTH(TODAY())-1,1)) ) Hope this helps! In article . com, wrote: 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 |
Count dates for previous month
Thank you very much, Domenic! That did the trick.
|
Count dates for previous month
|
All times are GMT +1. The time now is 08:01 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com