Offset Help

[Scrapyard]

Hello,
I'll do my best to explain and provide some examples.

- I have a sorted array of information, including dates in column A.
- I would like to use offset or some other function to put the month with the month changes, such as 28-May-24 is proceeded by 8-Jun-2024, which would put "June" between them.
- I cannot use scripts of any kind thanks to administrative restrictions.
- I have tried to use the offset function, but it produces some close but strange results.

Example:

Formula in AM: =IF(A2<>"",IFERROR(IF(MONTH(A2)<>MONTH(A1),FALSE,TRUE),FALSE),"")
Formula in AN: =IF(AM2<>"",COUNTIF($AM$2:$AM2,FALSE),"")
Formula in AO: =IF(OFFSET($AN2,-$AN2,0)=OFFSET($AN2,-$AN2,0),OFFSET(A2:AC2,-AN2-1,0), TEXT(OFFSET(A2,-AN2,0),"mmmm"))

I appreciate any help you can offer. I hope it is a simple fix.

Thanks!

 

[Scrapyard]

As I posted this, I recognized some of my mistakes and was able to resolve them. However, I'm uncertain how to "end" this. Maybe you know a good strategy to clean this up and have it work indefinately as intended.