Conditional Formatting Help

[Beatlepants]

Hello! I'm new to the community and semi decent at excel.

I have taken an excel template for Employee Attendance and modified it to suit the needs of my company. I'm in the final stages and I cannot seem to get the conditional formatting right. The top calendar is correct, but the bottom calendar should drop all the "red font cells" after 1 year (365 days) from the current day (today()).

The current formatting is :
=(MONTH(H43)=MONTH($C43))*(COUNTIFS(lstSdates,"<="&TODAY()-365))*(COUNTIFS(lstEmpNames,valSelEmployee2,lstSdates,"<="&H43,lstEDates,">="&H43,lstPoint4,">0")>0)

I've tried adding lstSdates,"<="&today()-365 in various places
I've tried adding lstSdates,"<="&EDate(Today(),-12) in various places as well.

For some reason I cannot get this format right. I only want it applied to the red font conditional formatting on the bottom calendar.

I've attempted to attach the file. Can anyone offer any insight? Thanks!

[dflak]

I added this as a new rule last in the sequence.
=AND(NOT(ISBLANK(H43)), H43 < TODAY()-365)
With format text to black.

I tried a test version with fill cells green and it shaded the appropriate cells.

[Beatlepants]

Thank you so much!

I used this formula and it is working for me !

=(MONTH(H43)=MONTH($C43))*(COUNTIFS(lstEmpNames,valSelEmployee2,lstSdates,"<="&H43,lstEDates,">="&H43,lstPoint4,">0")>0)*(H43>=TODAY()-365)