Hi,
I have a spreadsheet which contains dates in range B2:B100.
In the cell C2, I need to get the count of cells, in range B2:B100, which have dates in a given month, say 8.
The limitations are that I cannot add a separate column wherein I get the months using formula MONTH(..) and then use a COUNTIF with this new column as the range, to get the count of cells matching 8.
Please reply asap.
Regards,
Imsy
I have a spreadsheet which contains dates in range B2:B100.
In the cell C2, I need to get the count of cells, in range B2:B100, which have dates in a given month, say 8.
The limitations are that I cannot add a separate column wherein I get the months using formula MONTH(..) and then use a COUNTIF with this new column as the range, to get the count of cells matching 8.
Please reply asap.
Regards,
Imsy