JulianRennie
New Member
- Joined
- Feb 26, 2013
- Messages
- 1
Hi - I am trying to create a formula that will calculate the number of times selected dates occur (I am using month ends, quarter ends ,half year ends and calendar year ends) within a specified range that spans more than 1 year (the specified range can be monthly, quarterly, semi-annually and annually) . The formula can refer to a range of cells that have the DAY and MONTH shown.
I have been using the array formula {=SUM(IF(($A$2:$A$13<=G$2)*($A$2:$A$13>G$1),1,0))} for the monthly calculation but that requires me to have the YEAR included in the range shown in A2:A13.
Many thanks
I have been using the array formula {=SUM(IF(($A$2:$A$13<=G$2)*($A$2:$A$13>G$1),1,0))} for the monthly calculation but that requires me to have the YEAR included in the range shown in A2:A13.
Many thanks
