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!
Bookmarks