Nested if formula causing issues

Hi All,

I have been working on this formula for the past 2 days and just cannot bring it to the finish line. I believe I'm missing another false statement somewhere.

Row 5 is where I run into issues with the formula.

The logic:

-Columns O:AA should populate with either "1A", "1H", or blank depending on hire dates, term, dates, or lack of term date.

-I want column O to show 1A if the hire date (column K) is before 1/1/2025 and that there is no term date, or the term date is after 12/31/2025. If this case is not true I want column O to remain blank.

-If column O populates with 1A I want columns P:AA to show blank

-If column O is blank I want to run a formula which looks to see if the hire date (col O) is less than or equal to the start of the subsequent month in CY25. Example: Row 4, I want to assign the value 1A starting in July since their hire date is in June. I want to assign the value 1H in this row to anything before July, since they weren't hired until June.

-If they have both a hire date before or during CY25, and a term date. That is where I'm running into issues. I am getting a "False" value when both of those statements are true. In row 5 it should return "1A" for columns P:S and return "1H" columns T:AA.

My sanity and wife thank you in advance.

I hope I explained what I'm trying to do well enough.