Forum Discussion
Date Conditions
Dear fellow Excel enthusiasts, I'm working on a sheet and I'm confident this should be easy to get to work, but I can't seem to get to this right. The sheet holds the following collumns. Col...
It's better not to hardcode parameters, but keep the in separate cells.
Assume in H1 you have Piet, and in H2 any date in january, let say 2020-01-15 formatted as mmmm yyyy (i.e. January 2020).
When as variant it could be
=COUNTIFS(A:A,$H$1,B:B,">" & EOMONTH($H$2,-1), B:B,"<=" & EOMONTH($H$2,0) )
SergeiBaklanThanks a lot for your detailed explanation, I will have a look and see if it works out like this :-).