Counting date rows by month

[markmcm2021]

Hi,

I'm hoping someone can help me. I'm looking for a formula (replacing the red text in column C) that incrementally counts the number of rows in each month. When the month number changes in Column B the count must reset to 1 and increment accordingly before the next month change, and so on.

Any help would be gratefully appreciated.

Many thanks!
Mark.

[MrShorty]

I usually use an IF() function for this sort of thing:

1) C2 will always be 1, so enter 1 in C2.
2a) Test if month number for row 3 is the same as row 2 B3=B2
2b) If month number is the same, increment count C2+1
2c) If month number is not the same, reset count to 1
2d) Final IF() formula =IF(B3=B2,C2+1,1) entered in C3 and copied/pasted/filled down.

[markmcm2021]

Fantastic! Many, many thanks MrShorty :-)