Hi
I have a range of dates which falls into different months. I want a formula to count no of such dates fall (within the range) for given month.
Pls help me on this.. Thank you in advance
Thank you & it seems working ...
I need a small clarification, in my experience I have never come a cross the use of "&" in the count if formula
COUNTIF(A2:A100,">="&E1)-COUNTIF(A2:A100,">"&EOMONTH(E1,0))
Could you pls be kind enough to explain me the reason behind the use of "&" ?
Thank you in advance
Yes, I got now.
Thank you very much for taking time to explain me in this..
You are welcome. Thanks for providing feedback.
I have a similar problem... I have a start date and an end date and I need to know how many days from this range fall within certain months.
example:
1/15/16 2/9/16 How many days in range are in January? How many days are in February? etc.
Any help is greatly appreciated!!!