Identifying and then counting month ends in a column

[Red over White]

I have a series of dates in a column, and I want to identify which of these dates are 'month's end' date. I have included an image of what I am working with.

The dates in column A come from another sheet, and the dates in column B simply record the latest date in column A. There is only one month end date is a series of dates for a particular month.

I have been trying to come up with a formula that I can put in column C. The formula should identify and dates in column A that are 'month end dates' and then put '1' in column C, and if the date isn't one then an '0' instead. I will update the formula so that it starts to count the number in the range, and as count increases it then will act as a prompt to another column.

Thanks

 

[Skyybot]

Like this?

Book1
	A	B	C
1	11/1/2024	11/1/2024	0
2	11/5/2024	11/5/2024	0
3	11/6/2024	11/6/2024	0
4	11/7/2024	11/7/2024	0
5	11/24/2024	11/24/2024	0
6	11/30/2024	11/30/2024	1
Sheet1

Cell Formulas
Range	Formula
B1:B6	B1	=A1
C1:C6	C1	=IF(EOMONTH(A1,0)=A1,1,0)

 

[Red over White]

Thanks Skyybot

Could you extend your version so that it includes the date 12/31/2024 in column A with zeroes between that date and 11/30/24. When I extend the formula to the year end date there is no change, it stays at 1.

 

[Red over White]

Thanks Skyybot

Could you extend your version so that it includes the date 12/31/2024 in column A with zeroes between that date and 11/30/24. When I extend the formula to the year end date there is no change, it stays at 1.

Sorted it, =IF(EOMONTH(A3166,0)=A3166,C3165+1,C3165). Thanks again for your help

 

[Skyybot]

Nice. I had to add a Helper column to mine.

Book1
	A	B	C	D
1	11/1/2024	11/1/2024	0	0
2	11/5/2024	11/5/2024	0	0
3	11/6/2024	11/6/2024	0	0
4	11/7/2024	11/7/2024	0	0
5	11/24/2024	11/24/2024	0	0
6	11/30/2024	11/30/2024	1	1
7	12/31/2024	12/31/2024	1	2
8	1/31/2024	1/31/2024	1	3
Sheet1

Cell Formulas
Range	Formula
B1:B8	B1	=A1
C1:C8	C1	=IF(EOMONTH(A1,0)=A1,1,0)
D1:D8	D1	=IF(C1=1,SUM($C$1:C1),0)

 

[Cubist]

Try:

=C3165+(EOMONTH(A3166,0)=A3166)